From: Jie Liang <jie@stbernard.com>
To: Steve Brett <SBrett@e-mis.com>
To: David Hassell <davhas@bellsouth.net>
To: pgsql-sql@postgresql.org
Subject: Re: Function question
Date: Fri, 28 Jun 2002 08:26:43 -0700
Message-ID: <7C760DAA511DC74B99E7D22189F786F101BF2102@MAIL01.stbernard.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jie@stbernard.com, SBrett@e-mis.com, davhas@bellsouth.net
Subject: Re: Function question
In-Reply-To: <7C760DAA511DC74B99E7D22189F786F101BF2102@MAIL01.stbernard.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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