Hi list,
I am searching for function which creates or appends to array content of cursor.
I found that it is possible to get select result as array so it is
probably logical to have something similar for cursors.
I mean, there is copy-paste from documentation for 8.3 version:
-----
SELECT ARRAY(SELECT oid FROM pg_proc WHERE proname LIKE 'bytea%');
?column?
-------------------------------------------------------------
{2011,1954,1948,1952,1951,1244,1950,2005,1949,1953,2006,31}
(1 row)
------
What i want is to have some cursor, open it (with parameters optionally)
and just call some function which will fill my array with data from cursor.
I can do some iteration but it is really can be done in some universal
way I think.
Any suggestion?