Re: NOT HAVING clause?

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: NOT HAVING clause?
Дата
Msg-id 43D62B45.1020206@magproductions.nl
обсуждение исходный текст
Ответ на Re: NOT HAVING clause?  (Richard Huxton <dev@archonet.com>)
Ответы Re: NOT HAVING clause?  (Will Glynn <wglynn@freedomhealthcare.org>)
Список pgsql-general
Richard Huxton wrote:
> Alban Hertroys wrote:
> You're mixing up WHERE and HAVING. The WHERE clause applies to the
> individual rows before GROUP BY. The HAVING applies to the output of the
> GROUP BY stage.

Ah, of course, now it makes sense. Combined with Csaba's reply my
original problem has vaporized. Thank you guys :)

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
    7500 AK Enschede

//Showing your Vision to the World//

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: NOT HAVING clause?
Следующее
От: Tony Caduto
Дата:
Сообщение: Re: Does this look ethical to you?