BTW, the thing returned is not a record. It's a bunch of fields, not a complete record or fields of multiple records.
I'm not so sure it works.
On 22 Nov 2005, at 19:42, Jim Buttafuoco wrote:
create function abc() returns setof RECORD ...Met vriendelijke groeten,
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------- End of Original Message -------
to declare a type first ?
create function fnTest () returns setof
myDefinedTypeIDontWantToDefineFirst ...
Met vriendelijke groeten,
Bien à vous,
Kind regards,
Yves Vindevogel
Implements
Bien à vous,
Kind regards,
Yves Vindevogel
Implements
Mail: yves.vindevogel@xxxxxxxxxxxxx - Mobile: +32 (478) 80 82 91
Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76
Web: http://www.implements.be
<x-tad-smaller>
First they ignore you. Then they laugh at you. Then they fight you. Then you win.
Mahatma Ghandi.</x-tad-smaller>
