[SQL] plpgsql : adding record variable to table

[thomas veymont]

hi,

say I have the following (simplified for discussion) pl/pgsql function:

FUNCTION myfunction ( ...)  RETURNS TABLE ( elem1 integer, elem2 text, ...)
DECLARE
 g RECORD
BEGIN
  FOR g in SELECT colum1, column2 FROM someTable
    LOOP

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql