Hi, I'm trying to write a function that will take a name as a text value, and return an XML element with that name as name, like so:
create function xpercent(nam text, val int) returns xml as $$ begin return ( select xmlelement(name nam, concat(val::text, '%')) ); end; $$ language plpgsql; But when I call the function, nam is used as the name instead of what the parameter nam contains: select xpercent('hello', 4); xpercent --------------- <nam>4%</nam> (1 row) How can I get this to work so I get <hello>4%</hello instead? Thanks! –Ben -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql