From: Rod Taylor <rbt@rbt.ca>
To: Rajesh Kumar Mallah <mallah@trade-india.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: plpgsql Question..
Date: 28 Apr 2003 09:00:45 -0400
Message-ID: <1051534844.51984.8.camel@jester> (raw)
In-Reply-To: <200304281742.24167.mallah@trade-india.com>
References: <200304281742.24167.mallah@trade-india.com>
On Mon, 2003-04-28 at 08:12, Rajesh Kumar Mallah wrote:
> is it possible to access a feild in a RECORD type
> variable where the feild name is variable.
>
> eg say r is a record having feild name , email , salary
>
> r.name is 'foo'
> r.email is 'bar@foo.com'
> r.salary is 1000
>
> suppose feild_name iterates via a FOR LOOP
> through values (name , email , salary)
>
> is it possible to access that feild in record r
> inside the loop ?
Not that I'm aware of. What you can do it build the query to SELECT
<variable> FROM table.
Another alternative is to switch languages. A perl, tcl, etc. based
function would be capable of doing what you want.
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.ascAttachments:
signature.asc (application/pgp-signature, 186B) download
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: rbt@rbt.ca, mallah@trade-india.com
Subject: Re: plpgsql Question..
In-Reply-To: <1051534844.51984.8.camel@jester>
* 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