Postgres Pro
Downloads
Home   >   mailing lists

Thread: Function question

Function question

From
"David Hassell"
Date:
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

Re: Function question

From
Steve Brett
Date:
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

Re: Function question

From
Jie Liang
Date:
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