Re: Can we return a table from a function?

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