------=_Part_6740_11043075.1209410531406
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
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 do***entation where it states
that:
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.
Adam
------=_Part_6740_11043075.1209410531406
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
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 do***entation
where it states that:<br>
<br>Expressions in the <tt class="LITERAL">HAVING</tt> clause can refer
both to grouped expressions and to ungrouped expressions (which
necessarily involve an aggregate function).<br><br>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! :)<br>
<br>Thanks in advance for clearing this up for me.<br><br>Adam<br>
------=_Part_6740_11043075.1209410531406--
|
