plpgsql : adding record variable to table

From: thomas veymont <thomas(dot)veymont(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: plpgsql : adding record variable to table
Date: 2012-04-18 17:41:53
Message-ID: CAHcTkqptnZUN2g5Rp-ko4oO0X3K+Fh8LvVLypRwE5eS3BRZkDQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message thomas veymont 2012-04-18 17:55:55 plpgsql : adding record variable to table
Previous Message Tom Lane 2012-04-18 16:24:27 Re: Uniform UPDATE queries