On 11/20/2012 01:35 PM, Adrian Klaver wrote:
> On 11/20/2012 11:36 AM, Rhys A.D. Stewart wrote:
>> Greetings,
>>
>> I'm looking to obtain the name of a column that is passed to a function,
>> similar to xmlforest. Suggestions?
>
> This is going to require some more information.
>
> 1) What language is the function written in?
>
> 2) Trigger function or not?
>
> 3) A sample of the code?
>
>>
>> Regards,
>>
>>
>> Rhys
>
>
Is this along the right line(s)?
create or replace function f(cname text) returns table(c text)
as
$$
declare
v text;
begin
select 'hello' into v;
raise notice 'Column name is %', v;
execute 'select ' || v || ' as ' || cname;
end;
$$ language plpgsql;