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
Re: Select aliasses in where and other places of the selectlist?
Список 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 по дате отправления: