Postgres Pro
Downloads
Home   >   mailing lists

plpgsql : adding record variable to table - Mailing list pgsql-sql

From thomas veymont
Subject plpgsql : adding record variable to table
Date
Msg-id CAHcTkqptnZUN2g5Rp-ko4oO0X3K+Fh8LvVLypRwE5eS3BRZkDQ@mail.gmail.com
Whole thread Raw
List pgsql-sql
Tree view 
hi,

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

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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Uniform UPDATE queries
Next
From: thomas veymont
Date:
Subject: plpgsql : adding record variable to table