Re: Can we return a table from a function?

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Can we return a table from a function?
Date: 2004-09-02 21:38:23
Message-ID: ch83sr$9p5$1@floppy.pyrenet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Arundhati wrote:

> Hi
>
> I want the result of select query to be returned from a function. Or
> is there any way to return a table from a function?

What you are looking for is a table function:

http://www.postgresql.org/docs/7.3/interactive/xfunc-tablefunctions.html
http://www.postgresql.org/docs/7.4/interactive/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING

I'm not finding the equivalent for 7.4 about the first link.

Regards
Gaetano Mendola

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-09-02 21:43:28 Re: Debugging
Previous Message Vivek Khera 2004-09-02 20:59:46 Re: Foreign key locks