X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id AC27B475B47
	for <pgsql-sql@postgresql.org>; Mon, 28 Apr 2003 09:22:49 -0400 (EDT)
Received: from rtlocal.trade-india.com (unknown [203.196.129.235])
	by postgresql.org (Postfix) with SMTP id 6E201475956
	for <pgsql-sql@postgresql.org>; Mon, 28 Apr 2003 09:22:44 -0400 (EDT)
Received: (qmail 9037 invoked from network); 28 Apr 2003 13:23:18 -0000
Received: from unknown (HELO system67.trade-india-local.com) (unknown)
	by unknown with SMTP; 28 Apr 2003 13:23:18 -0000
From: Rajesh Kumar Mallah <mallah@trade-india.com>
Organization: Infocom Network Limited
To: Rod Taylor <rbt@rbt.ca>
Subject: Re: plpgsql  Question..
Date: Mon, 28 Apr 2003 18:53:37 +0530
User-Agent: KMail/1.5
Cc: pgsql-sql@postgresql.org
References: <200304281742.24167.mallah@trade-india.com>
	<1051534844.51984.8.camel@jester>
In-Reply-To: <1051534844.51984.8.camel@jester>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200304281853.37672.mallah@trade-india.com>
X-Spam-Status: No, hits=-33.1 required=5.0
	tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT,
	REFERENCES,REPLY_WITH_QUOTES,SIGNATURE_SHORT_SPARSE, USER_AGENT
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/413
X-Sequence-Number: 13114



Thanks rod ,

i am looking into the possibilities.

Regds
mallah.


On Monday 28 Apr 2003 6:30 pm, Rod Taylor wrote:
> 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.

-- 
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.