"David E. Wheeler" <david@kineticode.com> writes:
> I don't suppose that the position of the label and
> the value on either side of "AS" could be reversible, could it?
No. Consider
SELECT foo(bar AS baz) FROM ...
If the from-clause provides columns named both bar and baz, it would
be impossible to decide what is meant.
regards, tom lane