Skip site navigation (1) Skip section navigation (2)

Re: Stored Procedure

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 (view raw or flat)
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: Pasted Graphic 2.tiff
Description: image/tiff (5.6 KB)

In response to

Responses

pgsql-performance by date

Next:From: Yves VindevogelDate: 2005-11-22 22:20:09
Subject: Re: Stored Procedure
Previous:From: Scott MarloweDate: 2005-11-22 20:38:31
Subject: Re: High context switches occurring

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group