Re: plpgsql Question..

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah
Тема Re: plpgsql Question..
Дата
Msg-id 200304281853.37672.mallah@trade-india.com
обсуждение исходный текст
Ответ на Re: plpgsql Question..  (Rod Taylor <rbt@rbt.ca>)
Список pgsql-sql

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.



В списке pgsql-sql по дате отправления:

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: plpgsql Question..
Следующее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: plpgsql Question..