Re: SQL92 compliance - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: SQL92 compliance
Date
Msg-id 200608231811.48538.peter_e@gmx.net
Whole thread Raw
In response to SQL92 compliance  (Daniel CAUNE <d.caune@free.fr>)
Responses Re: SQL92 compliance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Am Mittwoch, 23. August 2006 03:40 schrieb Daniel CAUNE:
> Is AS in "SELECT my_column AS my_name FROM my_table" mandatory to be SQL92
> compliant?

No.  I have a patch at 
<http://developer.postgresql.org/~petere/select-without-as/select-without-as.patch> 
that fixes this at least for 7.4.  I don't think it works for newer versions, 
but it should give you an idea what is required to get it working.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-sql by date:

Previous
From: Erik Jones
Date:
Subject: Re: error with mor than 1 sub-select
Next
From: Tom Lane
Date:
Subject: Re: SQL92 compliance