Обсуждение: function::plpgsql::returning resultset

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?

thanks a lot, it is important!
can you send me your answers on esaracco@aspasia.fr

bye

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