| From: | Steve Brett <SBrett(at)e-mis(dot)com> |
|---|---|
| To: | David Hassell <davhas(at)bellsouth(dot)net>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Function question |
| Date: | 2002-06-28 13:38:11 |
| Message-ID: | C05E7DA1218ED411BF8A00105AC95A8E0599DEF9@sv-cntrmail.emis.local |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
i think you declare 'return set of int' as the retunr type of the function,
but i'm not sure if you can return a set of rows as a dataset from a
function. i guess you could define a data type as a row and retunr a set of
them but i'm only guessing as my knowledge /experience doesn't stretch that
far i'm afraid ....
Steve
-----Original Message-----
From: David Hassell [mailto:davhas(at)bellsouth(dot)net]
Sent: 27 June 2002 21:34
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] Function question
I am new to pgsql having worked with M$SQL for a while, my question would be
if functions are the equivelent to Stored Procedures, how does one return a
rowset, instead of a single typed variable? If this is the wrong group, my
apologies and please point me to the correct one.
Thanks,
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Brett | 2002-06-28 13:52:48 | Re: Subtraction of Dates |
| Previous Message | Jeff Boes | 2002-06-28 12:48:33 | Re: to_char() and order-by |