Thread

1. function::plpgsql::returning resultset

   Emmanuel SARACCO <emmanuel.saracco@d-interactive.com> — 2001-09-11T20:04:27Z

   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
   
   
   
   

2. Re: function::plpgsql::returning resultset

   Alex Pilosov <alex@pilosoft.com> — 2001-09-15T02:35:49Z

   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