Re: Converting from MS Access field aliases

* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

Hi,

> This is not an "extension", it is *directly* contrary to both
> the letter and spirit of the SQL standard.

at which point is this breaking the specification ?
What would happen if postgres would allow this ?

IMHO supporting aliases in where clauses would make some
queries easier to read. Think of cases where some column
is coming from an complex calculation (ie. many nested
CASE'es, etc, etc) and you need that calculated column
in the WHERE clause. Of course it's good style to encode
those things in views, but is this always very performant ?

cu
--
---------------------------------------------------------------------
Enrico Weigelt == metux IT service - http://www.metux.de/
---------------------------------------------------------------------
Please visit the OpenSource QM Taskforce:
http://wiki.metux.de/public/OpenSource_QM_Taskforce
Patches / Fixes for a lot dozens of packages in dozens of versions:
http://patches.metux.de/
---------------------------------------------------------------------