Select aliasses in where and other places of the selectlist? - Mailing list pgsql-general

From Arjen van der Meijden
Subject Select aliasses in where and other places of the selectlist?
Date
Msg-id 001d01c2f60c$f1a41ce0$3ac15e91@acm
Whole thread Raw
In response to Re: Query Help  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Select aliasses in where and other places of the  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Select aliasses in where and other places of the selectlist?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi List,

I know it isn't possible to do queries like:
SELECT 1 AS c, c + 1 AS d;

Other queries that aren't possible are those:
SELECT intfield AS a, intfield * intfield AS square FROM tableX WHERE a
< 10 AND square < 50

Of course, these are bogus examples to simply illustrate my point :)
But is there a good reason not to support it or is it something like
"not yet implemented", "not interesting" or "to complex to (easily)
implement".

Best regards,

Arjen


pgsql-general by date:

Previous
From: Peter Csaba
Date:
Subject: Rules / Triggers something a little bit more chellanging
Next
From: Dennis Gearon
Date:
Subject: Re: pg_dump data and foreign keys