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

Re: Stored Procedure

From: "Jim Buttafuoco" <jim(at)contactbda(dot)com>
To: Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Stored Procedure
Date: 2005-11-22 18:42:53
Message-ID: 20051122184119.M48526@contactbda.com (view raw or flat)
Thread:
Lists: pgsql-performance
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 -------


In response to

Responses

pgsql-performance by date

Next:From: Michael FuhrDate: 2005-11-22 18:59:42
Subject: Re: Stored Procedure
Previous:From: Yves VindevogelDate: 2005-11-22 18:29:37
Subject: Stored Procedure

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