From: Richard Albright <ralbright@insiderscore.com>
To: Collin Peters <cadiolis@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Possible to access value in RECORD without knowing column name?
Date: Wed, 02 May 2007 15:26:23 -0400
Message-ID: <1178133983.26840.5.camel@MSI1036> (raw)
In-Reply-To: <df01c91b0705021217j2fc03527pc06339c954ab5ffd@mail.gmail.com>
References: <df01c91b0705021217j2fc03527pc06339c954ab5ffd@mail.gmail.com>
my_column = 'foo'
sql = 'select col1, col2, ' || my_column || ' as bar from mytable;
for myrecord in execute sql
loop
myvariable = 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ralbright@insiderscore.com, cadiolis@gmail.com
Subject: Re: Possible to access value in RECORD without knowing column name?
In-Reply-To: <1178133983.26840.5.camel@MSI1036>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox