Re: Return a set of values from postgres Function

On Thu, 17 Jul 2003, Derrick Betts wrote:

> I want to get a set of values returned from a function. The values
> (there will need to be four of them) come from 4 separate SELECT
> statements inside the Function. For example SELECT one INTO variable1
> from table1 where ... then SELECT two INTO variable2 from table1
> where... At first you might think I could just combine the select
> statements into one statement, but I can't. I need to pass the
> results of each separate select statement into distinct variables and
> return them together to the application.

I'd suggest reading one of the items on the set returning functions:

http://www.varlena.com/GeneralBits/26.html
http://techdocs.postgresql.org/guides/SetReturningFunctions