Re: Converting from MS Access field aliases

Adam Tauno Williams <adamtaunowilliams@gmail.com> writes:
> On Thu, 2007-07-12 at 13:23 -0400, Tom Lane wrote:
>> chester c young <chestercyoung@yahoo.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