Обсуждение: Is there a simple function for copiing cursor data into array?

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?

Hello

2008/11/3 alebu <aleboo@gmail.com>:
> 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?
>

I am afraid there isn't any simply way

Pavel

> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>