Re: adressing column

thanx a lot.
i thought much to complicated!
this will work in my case perfectly!

Richard Huxton wrote:

>On Wednesday 01 October 2003 11:20, Stefan Leitich wrote:
>
>
>>i have the following function:
>>
>>
>[snip code]
>
>
>>now i am searching for a way, to access my_column in my_record (now it
>>just works if my_column = 'col')
>>can anyone help please!
>>
>>
>
>That's not going to work in plpgsql at the moment. Because it's "compiled", it
>has problems with things like this.
>
>The usual answer is to use pltcl or some other more dynamic language.
>
>In you particular example you could just build your execute statement as:
> ... || my_column || ' AS foo FROM ' || ...
>
>Then you can access the column as "foo"
>
>