Обсуждение: 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 >