create function abc() returns setof RECORD ... then to call it you would do select * from abc() as (a text,b int,...); ---------- Original Message ----------- From: Yves Vindevogel <yves.vindevogel@xxxxxxxxxxxxx> To: pgsql-performance@xxxxxxxxxxxxxx Sent: Tue, 22 Nov 2005 19:29:37 +0100 Subject: [PERFORM] Stored Procedure > Is there another way in PG to return a recordset from a function than > to declare a type first ? > > create function fnTest () returns setof > myDefinedTypeIDontWantToDefineFirst ... > > Met vriendelijke groeten, > Bien à vous, > Kind regards, > > Yves Vindevogel > Implements ------- End of Original Message -------