Re: [SQL] SQL92 compliance

2006-08-23 Thread Peter Eisentraut
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

Re: [SQL] SQL92 compliance

2006-08-23 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: 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

Re: [SQL] SQL92 compliance

2006-08-23 Thread Scott Marlowe
On Wed, 2006-08-23 at 12:40, Tom Lane wrote: Peter Eisentraut [EMAIL PROTECTED] writes: 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

[SQL] SQL92 compliance

2006-08-22 Thread Daniel CAUNE
Hi, Is AS in SELECT my_column AS my_name FROM my_table mandatory to be SQL92 compliant? PostgreSQL requires this keyword by default when defining alias, which might be good thing. I mean, I would prefer being notified from a syntax error than spending a couple of hours wondering why a client

Re: [SQL] SQL92 compliance

2006-08-22 Thread Michael Glaesemann
On Aug 23, 2006, at 10:40 , Daniel CAUNE wrote: Hi, Is AS in SELECT my_column AS my_name FROM my_table mandatory to be SQL92 compliant? You can find this in the documentation: http://www.postgresql.org/docs/8.1/interactive/sql-select.html#AEN48391 The AS Key Word In the SQL standard,