From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | adamtaunowilliams(at)gmail(dot)com |
Cc: | sql pgsql <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Converting from MS Access field aliases |
Date: | 2007-07-12 22:48:31 |
Message-ID: | 13141.1184280511@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Adam Tauno Williams <adamtaunowilliams(at)gmail(dot)com> writes:
> On Thu, 2007-07-12 at 13:23 -0400, Tom Lane wrote:
>> chester c young <chestercyoung(at)yahoo(dot)com> writes:
>>> SELECT field1 / 2 AS foo,
>>> field2 * 2 AS bar,
>>> foo + bar AS total
>>> WHERE foo < 12;
>> This is not an "extension", it is *directly* contrary to both the letter
>> and spirit of the SQL standard.
> "AS" works in Informix, and I believe, in DB2 as well.
I can't speak to Informix, but I will bet a good lunch that it does not
work like that in DB2. DB2 is one of the more nearly
standard-conformant databases on the planet. (Or possibly it's the
other way around ... there seem to be a lot of IBMers on the committee.)
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Nis Jørgensen | 2007-07-13 06:36:01 | Re: Converting from MS Access field aliases |
Previous Message | Gregory Stark | 2007-07-12 22:14:47 | Re: Query Plan |