Re: PL/PGSQL: another Q - Mailing list pgsql-general

From Patrick Fiche
Subject Re: PL/PGSQL: another Q
Date
Msg-id 85058ADF852DD5118FD50002A528A5B6079B38@SERVEUR
Whole thread Raw
In response to PL/PGSQL: another Q  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
This is available is 7.3 version.
See http://developer.postgresql.org/docs/postgres/xfunc-sql.html#AEN31522

Patrick

----------------------------------------------------------------------------
---------------
Patrick Fiche
email : patrick.fiche@aqsacom.com
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------


-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Jean-Christian
Imbeault
Sent: Friday, January 17, 2003 7:34 AM
To: pgsql-general
Subject: [GENERAL] PL/PGSQL: another Q


I've gone through the books I have and searched the web but can't find
an answer to this question.

Is it possible to have a plpgsql function return a result set (rows)? If
so what do I declare the return type as?

I know it sounds silly but the reason would be that I have these
extremely long queries that I hate typing. I'd love to just create a
function, do a "SELECT myfunc(1,2,3,4,5,6,7)" and have the function spew
out the result set (rows). So far I can only find example on how to get
PL/PGSQL to return a single value.

Can this be done in PL/PGSQL?

Any pointers to reference material greatly appreciated!

Jc


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: PL/PGSQL: another Q
Next
From: "Patrick Fiche"
Date:
Subject: Re: PL/PGSQL: another Q