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;
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
