Re: NOT HAVING clause?

From: Alban Hertroys <alban(at)magproductions(dot)nl>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Michael Glaesemann <grzm(at)myrealbox(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: NOT HAVING clause?
Date: 2006-01-24 13:27:33
Message-ID: 43D62B45.1020206@magproductions.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)magproductions(dot)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//

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2006-01-24 13:56:22 Re: Does this look ethical to you?
Previous Message Richard Huxton 2006-01-24 13:02:24 Re: NOT HAVING clause?