pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Function question 3+ messages / 3 participants [nested] [flat]
* Function question @ 2002-06-27 20:33 David Hassell <davhas@bellsouth.net> 0 siblings, 0 replies; 3+ messages in thread From: David Hassell @ 2002-06-27 20:33 UTC (permalink / raw) To: pgsql-sql 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Function question @ 2002-06-28 13:38 Steve Brett <SBrett@e-mis.com> 0 siblings, 0 replies; 3+ messages in thread From: Steve Brett @ 2002-06-28 13:38 UTC (permalink / raw) To: David Hassell <davhas@bellsouth.net>; 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@bellsouth.net] Sent: 27 June 2002 21:34 To: pgsql-sql@postgresql.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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Function question @ 2002-06-28 15:26 Jie Liang <jie@stbernard.com> 0 siblings, 0 replies; 3+ messages in thread From: Jie Liang @ 2002-06-28 15:26 UTC (permalink / raw) To: Steve Brett <SBrett@e-mis.com>; David Hassell <davhas@bellsouth.net>; pgsql-sql Before v7.2, you have no way to resolve this, however, from v7.2, you can return a cursor with PL/pgSQL, so I think you may resolve this problem by cursor. But I haven't tested it yet. Jie Liang -----Original Message----- From: Steve Brett [mailto:SBrett@e-mis.com] Sent: Friday, June 28, 2002 6:38 AM To: David Hassell; pgsql-sql@postgresql.org Subject: Re: [SQL] Function question 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@bellsouth.net] Sent: 27 June 2002 21:34 To: pgsql-sql@postgresql.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 ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-06-28 15:26 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2002-06-27 20:33 Function question David Hassell <davhas@bellsouth.net> 2002-06-28 13:38 Re: Function question Steve Brett <SBrett@e-mis.com> 2002-06-28 15:26 Re: Function question Jie Liang <jie@stbernard.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox