Steve Lane wrote:
> Hello all:
>
> I thought I had understood that the AS keyword for column aliasing was
> optional in SQL. Yet it appears that, at least some of the time, it's
> necessary in Postgresql. Have I misunderstood the standard, or does postgres
> deliberately diverge?
PostgreSQL intentionally diverges. See (near the bottom - SQL92 heading):
http://www.postgresql.org/idocs/index.php?sql-select.html
Joe