Thread: Possible to access value in RECORD without knowing column name?

Possible to access value in RECORD without knowing column name?

From
"Collin Peters"
Date:
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


Re: Possible to access value in RECORD without knowing column name?

From
Richard Albright
Date:
my_column = 'foo'
sql = 'select col1, col2, ' || my_column || ' as bar from mytable;
for myrecord in execute sql
loopmyvariable = myrecord.bar
end loop;

On Wed, 2007-05-02 at 12:17 -0700, Collin Peters wrote:
> 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 majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
-- 
Rick Albright
Senior Quantitative Analyst
Indie Research, LLC
254 Witherspoon Street
Princeton, NJ 08542
(609)497-1030
ralbright@insiderscore.com