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
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных