AW: [HACKERS] SELECT ... AS ... names in WHERE/GROUP BY/HAVING

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: [HACKERS] SELECT ... AS ... names in WHERE/GROUP BY/HAVING
Дата
Msg-id 219F68D65015D011A8E000006F8590C603FDC1D1@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список pgsql-hackers
> So, according to Oracle's view of the world, HAVING is orrect 
> because it
> rejects aliases, but GROUP BY is broken because it accepts them.

Just because it is more powerful than the standard does not mean it is
broken.
The only thing, that is broken is that the alias is taken before the
colname,
and thus results in wrong output for a standard conformant query.

Andreas


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Zeugswetter Andreas SB
Дата:
Сообщение: Re: [HACKERS] SELECT ... AS ... names in WHERE/GROUP BY/HAVIN G
Следующее
От: Jose Soares
Дата:
Сообщение: \copy problem