HAVING clause

> Send the bug report to here and Stefan (he is on the TODO list).
> Let's see if he can fix it.

Hi Stefan. I ran across some funny behavior with the HAVING clause:

-- try a having clause in the wrong order (OK, my mistake :)
postgres=> select x.x, count(y.i) from t x, t y
group by x.x having x.x = 'four';
PQexec() -- Request was sent to backend, but backend closed
the channel before responding. This probably means the backend
terminated abnormally before or while processing the request.

<start over>
-- works better when it is a good query...
postgres=> select x.x, count(y.i) from t x, t y
group by x.x having count(y.i) = 40;
x |count
----+-----
four| 40
(1 row)

Table is defined below...

- Tom

postgres=> create table t (x text, i int);

<populate the table; one entry for 'one', two for 'two', etc>

postgres=> select x, i, count(i) from t group by x, i;
x |i|count
-----+-+-----
four |4| 4
one |1| 1
three|3| 3
two |2| 2
(4 rows)