From: Tom Lane <tgl@sss.pgh.pa.us>
To: chester c young <chestercyoung@yahoo.com>
Cc: Joel Richard <postgres@joelrichard.com>
Cc: sql pgsql <pgsql-sql@postgresql.org>
Subject: Re: Converting from MS Access field aliases
Date: Thu, 12 Jul 2007 13:23:00 -0400
Message-ID: <634.1184260980@sss.pgh.pa.us> (raw)
In-Reply-To: <746273.93291.qm@web54305.mail.re2.yahoo.com>
References: <746273.93291.qm@web54305.mail.re2.yahoo.com>
chester c young <chestercyoung@yahoo.com> writes:
>> SELECT field1 / 2 AS foo,
>> field2 * 2 AS bar,
>> foo + bar AS total
>> WHERE foo < 12;
> First, I think it would be great if this worked - like the alias to an
> update table added in 8.2 - saves a lot of typing and makes queries
> much more readable.
This is not an "extension", it is *directly* contrary to both the letter
and spirit of the SQL standard. I can hardly believe that M$ did that
... oh, actually, I can entirely believe it. The OP has a serious
problem of vendor lockin now, and that's exactly what M$ wants.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, chestercyoung@yahoo.com, postgres@joelrichard.com
Subject: Re: Converting from MS Access field aliases
In-Reply-To: <634.1184260980@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox