Ken Johanson wrote:
I notice PG doesn't allow shorthand column labels -- it requires the
'AS' operand.
SELECT col1 foo, ...; -> ERROR: syntax error at or near "foo"
For compatibility with other databases, what objections might be argued
in allowing this syntax in the future?
On the 'pros' side I think it eases migration to PG, shortens code, is
similar syntax to shorthand table aliases, and some users might argue it
has become defacto syntax among DBs.
Regards,
Ken
Briefly discussed a couple of weeks ago.
See http://archives.postgresql.org/pgsql-general/2008-01/msg00089.php
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
