Subject: Re: plpgsql  Question..
From: Rod Taylor <rbt@rbt.ca>
To: Rajesh Kumar Mallah <mallah@trade-india.com>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <200304281742.24167.mallah@trade-india.com>
References: <200304281742.24167.mallah@trade-india.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-+ftl3YXGYU6K1a751dTJ"
Organization: 
Message-Id: <1051534844.51984.8.camel@jester>
Mime-Version: 1.0
Date: 28 Apr 2003 09:00:45 -0400

--=-+ftl3YXGYU6K1a751dTJ
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Mon, 2003-04-28 at 08:12, Rajesh Kumar Mallah wrote:
> is it possible to access a feild in a RECORD type=20
> variable where the feild name is variable.
>=20
> eg say r is a record having feild name , email , salary
>=20
> r.name is 'foo'
> r.email is 'bar@foo.com'=20
> r.salary is 1000
>=20
> suppose  feild_name iterates via a FOR LOOP
> through values (name , email , salary)
>=20
> 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.

--=20
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

--=-+ftl3YXGYU6K1a751dTJ
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (FreeBSD)

iD8DBQA+rSX86DETLow6vwwRAgHCAJwPLocGLsrF/A9WTToLnF80V+1PeACeJB8v
G4wkNVajtDQpjzh+ObLd7gM=
=DCVk
-----END PGP SIGNATURE-----

--=-+ftl3YXGYU6K1a751dTJ--