Re: dynamic OUT parameters?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>, pgsql-sql(at)postgresql(dot)org
Subject: Re: dynamic OUT parameters?
Date: 2009-01-30 17:08:50
Message-ID: 25102.1233335330@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Craig Ringer <craig(at)postnewspapers(dot)com(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message gherzig 2009-01-31 00:52:11 Re: dynamic OUT parameters?
Previous Message Craig Ringer 2009-01-30 17:00:50 Re: dynamic OUT parameters?