Re: function::plpgsql::returning resultset

On Tue, 11 Sep 2001, Emmanuel SARACCO wrote:

> hi,
> 
> how can I write a plpgsql function who return the entire rows of a table?
> for example, if I want to return all the lines in SELECT * FROM mytable.
> 
> it seems to be possible with a C function, but is it possible too with a
> plpgsql function?
Not currently.

In 7.2, you will be able to return a cursor, which is probably good enough
for your purposes (when the ultimate result is a SQL query).

If you want to build rows 'by hand', not yet, but its being worked on.

-alex