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