Select aliasses in where and other places of the selectlist?

From: Arjen van der Meijden <acm(at)tweakers(dot)net>
To: 'Postgre General' <pgsql-general(at)postgresql(dot)org>
Subject: Select aliasses in where and other places of the selectlist?
Date: 2003-03-29 16:04:51
Message-ID: 001d01c2f60c$f1a41ce0$3ac15e91@acm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-03-29 16:11:19 Re: pg_dump data and foreign keys
Previous Message Peter Csaba 2003-03-29 16:03:17 Rules / Triggers something a little bit more chellanging