Re: Stored Procedure - Mailing list 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:


<excerpt>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


<excerpt>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

</excerpt>------- End of Original Message -------




</excerpt>Met vriendelijke groeten,

Bien à vous,

Kind regards,


<bold>Yves Vindevogel</bold>

<bold>Implements</bold>

<smaller>

</smaller>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.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 -------
>
>
>
Met vriendelijke groeten,
Bien à vous,
Kind regards,

Yves Vindevogel
Implements

<smaller>


Mail: yves.vindevogel@implements.be  - Mobile: +32 (478) 80 82 91


Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76


Web: http://www.implements.be

<italic><x-tad-smaller>

First they ignore you.  Then they laugh at you.  Then they fight you.
Then you win.

Mahatma Ghandi.</x-tad-smaller></italic></smaller>



Mail: yves.vindevogel@implements.be  - Mobile: +32 (478) 80 82 91

Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76

Web: http://www.implements.be

First they ignore you.  Then they laugh at you.  Then they fight you.
Then you win.
Mahatma Ghandi.