Re: Using Cursor in PostgreSQL 7.2 - Mailing list pgsql-general

From Tom Lane
Subject Re: Using Cursor in PostgreSQL 7.2
Date
Msg-id 934.1007746683@sss.pgh.pa.us
Whole thread Raw
In response to Re: Using Cursor in PostgreSQL 7.2  (Doug McNaught <doug@wireboard.com>)
Responses Re: Using Cursor in PostgreSQL 7.2
List pgsql-general
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

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Using Cursor in PostgreSQL 7.2
Next
From: "Roderick A. Anderson"
Date:
Subject: Re: When do I Vacuum ?