From: Jim Buttafuoco <jim@contactbda.com>
To: Yves Vindevogel <yves.vindevogel@implements.be>
To: pgsql-performance@postgresql.org
Subject: Re: Stored Procedure
Date: Tue, 22 Nov 2005 13:42:53 -0500
Message-ID: <20051122184119.M48526@contactbda.com> (raw)
In-Reply-To: <e28aace15975ef9972fdd65ceb6e0ce8@implements.be>
References: <e28aace15975ef9972fdd65ceb6e0ce8@implements.be>
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@implements.be>
To: pgsql-performance@postgresql.org
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 -------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jim@contactbda.com, yves.vindevogel@implements.be
Subject: Re: Stored Procedure
In-Reply-To: <20051122184119.M48526@contactbda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox