From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Doug McNaught <doug(at)wireboard(dot)com> |
Cc: | Holger Krug <hkrug(at)rationalizer(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Using Cursor in PostgreSQL 7.2 |
Date: | 2001-12-07 17:38:03 |
Message-ID: | 934.1007746683@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-patches |
C functions returning sets are entirely possible, and there's even some
documentation about how to do it in src/backend/utils/fmgr/README (which
needs to be transposed to present tense and moved into the SGML docs,
but it's better than nothing).
There is at least one simple example in the 7.2 sources: see
pg_stat_get_backend_idset() in src/backend/utils/adt/pgstatfuncs.c,
and observe its usage in the pg_stat views, eg at the bottom of
http://developer.postgresql.org/docs/postgres/monitoring-stats.html
There is not presently any support for this sort of thing in plpgsql
or any of the other PL languages, however.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Roderick A. Anderson | 2001-12-07 17:55:28 | Re: When do I Vacuum ? |
Previous Message | Doug McNaught | 2001-12-07 17:07:40 | Re: Using Cursor in PostgreSQL 7.2 |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2001-12-07 17:41:13 | Re: ODBC functions in gram.y |
Previous Message | Joe Conway | 2001-12-07 17:26:47 | Re: Remote connections? |
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2001-12-07 18:45:23 | Re: Using Cursor in PostgreSQL 7.2 |
Previous Message | Thomas Lockhart | 2001-12-07 17:12:53 | Re: Third call for platform testing |