In plpgsl, if I have a RECORD variable that is populated via some
dynamic SQL, is it possible to access the columns in that RECORD
object without knowing the column names? I.e. Can I grab whatever
value is the 3rd column?
random_colname = 'foobar';
sql = 'SELECT col1, col2, ' || random_colname || ' FROM table';
FOR mviews IN EXECUTE sql LOOP
--possible to access 3rd column of mviews? something like mviews[3]?
END LOOP;
Regards,
Collin
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
