Hi, I have a question, that's probably really stupid, but could someone
please explain to me what difference there is between a WHERE clause and a
HAVING clause besides the syntax? I read the documentation where it states
Expressions in the HAVING clause can refer both to grouped expressions and
to ungrouped expressions (which necessarily involve an aggregate function).
I've been happily working with Postgres for a long time, and not once have I
ever used a HAVING in my queries, even in fairly complex ones, and I just
can't bear the suspense anymore! :)
Thanks in advance for clearing this up for me.
pgsql-novice by date
|Next:||From: Richard Broersma||Date: 2008-04-28 19:45:12|
|Subject: Re: difference between 'where' and 'having'|
|Previous:||From: Tom Lane||Date: 2008-04-26 20:07:47|
|Subject: Re: index with no column |