Postgres Pro
Downloads
Home   >   mailing lists

Re: Returning multiple rows from a function? - Mailing list pgsql-general

From Volkan YAZICI
Subject Re: Returning multiple rows from a function?
Date
Msg-id 20061127172857.GB1448@alamut
Whole thread Raw
In response to Returning multiple rows from a function?  (Bret Schuhmacher <bret@thelastmilellc.com>)
List pgsql-general
Tree view 
On Nov 27 11:59, Bret Schuhmacher wrote:
> I'm trying to return multiple rows from a function, but all I can get
> ...
>
> CREATE OR replace function getOnCallVol() RETURNS RECORD AS $$

You should return "SETOF record". See related section of the manual
about SRFs (Set Returning Fucntions).


Regards.

pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: OID Perfomance - Object-Relational databases
Next
From: Scott Marlowe
Date:
Subject: Re: IS it a good practice to use SERIAL as Primary Key?