Postgres Pro
Downloads
Home   >   mailing lists

Re: dynamic OUT parameters? - Mailing list pgsql-sql

From Tom Lane
Subject Re: dynamic OUT parameters?
Date
Msg-id 25102.1233335330@sss.pgh.pa.us
Whole thread Raw
In response to Re: dynamic OUT parameters?  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-sql
Tree view 
Craig Ringer <craig@postnewspapers.com.au> writes:
>> 2) Can i make a special type "on_the_fly" and returning setof "that_type"?

> You're better off using SETOF RECORD, at least in my opinion.

Another possibility is to return a cursor.
        regards, tom lane

pgsql-sql by date:

Previous
From: Craig Ringer
Date:
Subject: Re: dynamic OUT parameters?
Next
From: gherzig@fmed.uba.ar
Date:
Subject: Re: dynamic OUT parameters?