Referencing Cursor/Row/Record Fields in PL/PgSQL

From: Lee Hughes <lee(at)hughesys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Referencing Cursor/Row/Record Fields in PL/PgSQL
Date: 2009-02-10 21:15:22
Message-ID: 2d739b560902101315s3118915w37fe0b4b488524c1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Trying to figure out how to reference a field in a cursor result, or in a
row/record variable that I've FETCHed the cursor into, where the target
field name is in a variable or parameter. I think I'm just missing the
dereferencing syntax. I've studied the manual and tried using EXECUTE to no
avail.

Worst case, if I could just reference the Nth field, then I could combine
with pg_attribute info to get what I need.

Thanks for any help-

Lee

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-02-10 21:22:22 Re: Referencing Cursor/Row/Record Fields in PL/PgSQL
Previous Message Tom Lane 2009-02-10 20:31:20 Re: tablelog