On Fri, 2008-08-15 at 14:54 +0200, Pavel Stehule wrote: > 2008/8/15 Peter Eisentraut <[EMAIL PROTECTED]>: > > Am Thursday, 14. August 2008 schrieb Pavel Stehule: > >> I propose enhance current syntax that allows to specify label for any > >> function parameter: > >> > >> fcename(expr [as label], ...) > >> fcename(colname, ...) > >> > >> I would to allow same behave of custom functions like xmlforest function: > >> postgres=# select xmlforest(a) from foo; > >> xmlforest > >> ----------- > >> <a>10</a> > >> (1 row) > > > > Do you have a use case for this outside of XML? > > > > JSON and similar (custom) protocols
why not use a format string, or any other separate (sub)language ? select json('[name:$1, age: $2]', name, age) from students; ------------ Hannu -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers