SQL92 compliance

From: Daniel CAUNE <d(dot)caune(at)free(dot)fr>
To: pgsql-sql(at)postgresql(dot)org
Subject: SQL92 compliance
Date: 2006-08-23 01:40:03
Message-ID: 000301c6c655$0e3a0100$0b00a8c0@tedy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 application, at the
end of a several data marshalling processes, doesn't get the right data...
For instance MySQL doesn't require it and sometimes that sucks:

SELECT my_column1
my_column2,
my_column3
FROM my_table

Regards,

--
Daniel

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message chrisj 2006-08-23 01:47:51 error with mor than 1 sub-select
Previous Message Stephan Szabo 2006-08-22 16:59:29 Re: joining VIEWs