Re: plpgsql Question..

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(at)foo(dot)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(at)rbt(dot)ca>

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