I thought that's what EXECUTE was for in plpgsql -- isn't there a way to extract the value of a field in a row/record variable by building a SELECT string and passing it to EXECUTE?
On Tue, Feb 10, 2009 at 1:22 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Lee Hughes <l...@hughesys.com> writes: > > 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. > > There isn't any --- plpgsql doesn't deal in accesses to unknown fields > (mainly because it can't know their type, and it's a strongly typed > language). Consider plperl or plpython or pl-anything-but-pgsql. > > regards, tom lane >
