Has anyone successfully used the "ANY", "ALL", or "SOME" clause using
arrays? Cant seem to get this to work. Heres the gist of my function
which returns a SETOF INTEGER[]...
DECLARE
id_var INTEGER[];
record_var RECORD;
BEGIN
id_var[0] := 1;
id_var[1] := 2;
id_var[2] := 3;
FOR record_va
Is it possible to have a function variable hold a recordset? Kind of
like this...
DECLARE
recordset_var RECORD[];
BEGIN
recordset_var := (SELECT id FROM myTable);
/*
loop through a ton of different tables where column IN
(recordset_var)
*/
END;
Thanks for any help! -Nick
-
I set the array count to start at 1, but still not working. Im using
v8. Ive also read that the ANY clause runs rediculously slow. Is there
another way to convert an array into a record set without writing a
separate function for that? Is it even possible to create a record set
variable in a functi
The problem was fixed by initializing the array before giving it a
value. Not surprising Postges isnt as popular as it should be. I was by
luck that I found this out - the manual says nothing about init arrays.
DECLARE
id_var INTEGER[];
record_var RECORD;
BEGIN
id_var := '{}';
id_var[0] :=
Oracle keeps looking more and more appealing. $$$ vs actually being
able to get stuff done?
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
