From: | Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Stored Procedure |
Date: | 2005-11-22 22:17:41 |
Message-ID: | 33f74d2a046b89d119c349e82b7398de@implements.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
But this does not work without the second line, right ?
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 ...
>
> then to call it you would do
> select * from abc() as (a text,b int,...);
>
>
>
>
> ---------- Original Message -----------
> From: Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be>
> To: pgsql-performance(at)postgresql(dot)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 -------
>
>
>
Met vriendelijke groeten,
Bien à vous,
Kind regards,
Yves Vindevogel
Implements
Attachment | Content-Type | Size |
---|---|---|
Pasted Graphic 2.tiff | image/tiff | 5.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Yves Vindevogel | 2005-11-22 22:20:09 | Re: Stored Procedure |
Previous Message | Scott Marlowe | 2005-11-22 20:38:31 | Re: High context switches occurring |