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