Thread: return multiple rows

On Fri, 23 May 2003, Sidar Lopez Cruz wrote:

> how to return multiple rows and columns from functions

Joe Conway gave a pretty good list of resources in the
following message a few days ago:

http://archives.postgresql.org/pgsql-sql/2003-05/msg00405.php

Sidar Lopez Cruz wrote:
> how to return multiple rows and columns from functions
>

See:
http://techdocs.postgresql.org/guides/SetReturningFunctions
http://www.brasileiro.net:8080/postgres/cookbook/view-one-recipe.adp?recipe_id=11378
http://www.varlena.com/GeneralBits/26.html

There are plpgsql and sql function examples in the mailing list
archives. Couple of examples:
   http://archives.postgresql.org/pgsql-general/2002-10/msg00022.php
and
   http://archives.postgresql.org/pgsql-general/2002-12/msg00426.php

And finally, in the manual see:
general ->
http://developer.postgresql.org/docs/postgres/xfunc-tablefunctions.html
sql ->
http://developer.postgresql.org/docs/postgres/xfunc-sql.html (sec 9.2.4)
C ->
http://developer.postgresql.org/docs/postgres/xfunc-c.html (sec 9.5.6)
plpgsql ->
http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html
usage ->
http://developer.postgresql.org/docs/postgres/sql-select.html
(from_item, inputs, from clause, usage)

Joe

On Friday 23 May 2003 18:58, Sidar Lopez Cruz wrote:
> how to return multiple rows and columns from functions

This is top secret information you can find only on this
carefully hidden page:
http://www.postgresql.org/docs/faqs/FAQ.html

(question 4.25).

Please don't tell anyone else!

 ;-)

Ian Barwick
barwick@gmx.net