> I personally agree that AS seems more SQL-ish, but that's in the eye > of the beholder. > > The argument about ambiguity in XMLELEMENT is bogus becase XMLELEMENT > doesn't (and won't) have named parameters. But it is true that > XMLELEMENT is doing something subtly different with the AS clause than > what a named parameter would do; so you could argue that there's a > potential for user confusion there.
It's not ambiguous unless for some reason you wanted to support doing both of those things at the same time, but I'm having a hard time coming up with a realistic use case for that. Still, I think we probably do want to at least leave the door open to do both things at different times. For the XMLELEMENT-type case, "value AS label" seems far superior to "label: value", so if you're going to pick one syntax for both things, it should be that one. Alternatively, using "label: value" for identifying which parameter is intended to get the value and "value AS label" for relabelling seems OK too, though your argument about standards-compliance is a valid one. ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers