2008/12/14 Greg Stark <st...@enterprisedb.com>: > On Sun, Dec 14, 2008 at 1:42 AM, Robert Haas <robertmh...@gmail.com> wrote: >>> What if relabeling support were to spread some more? >> >> The only example I can think of besides XML is JSON. There might be a >> few more. Basically, relabelling is a handy shortcut when you are >> serializing data and want to avoid specifying a list of columns and an >> (almost) identical list of labels. > > The whole relabeling thing seems like a seriously silly idea. Why is > it at all a shortcut to use "AS" instead of "," ? The relabeling adds > zero actual expressiveness, it just makes a fancy way to pass an > argument. > >
Because AS is signal for collecting column (or label) names. I thing so we should use "AS" as Tom's proposal, together with SQL/XML functionality. It's only idea: default behave is using as for param name specification, seconf with flag maybe labeled allows using AS in SQL/XML behave But this syntax don't allow use this feature together (it is maybe enought).\ create function json(variadic labeled values int[]) ... Pavel -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
