Select aliasses in where and other places of the selectlist?

Поиск
Список
Период
Сортировка
От Arjen van der Meijden
Тема Select aliasses in where and other places of the selectlist?
Дата
Msg-id 001d01c2f60c$f1a41ce0$3ac15e91@acm
обсуждение исходный текст
Ответ на Re: Query Help  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Peter Csaba
Дата:
Сообщение: Rules / Triggers something a little bit more chellanging
Следующее
От: Dennis Gearon
Дата:
Сообщение: Re: pg_dump data and foreign keys