Re: Converting from MS Access field aliases

* Tom Lane <tgl@sss.pgh.pa.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_TaskforcePatches/ Fixes for a lot dozens of packages in dozens of
versions:http://patches.metux.de/
---------------------------------------------------------------------