Re: [HACKERS] error on HAVING clause

> Please enter a FULL description of your problem:
> ------------------------------------------------
>
> COUNT(*) doesn't work with HAVING
>
>
> Please describe a way to repeat the problem. Please try to provide a
> concise reproducible example, if at all possible:
>
> ----------------------------------------------------------------------
>
> SELECT PNO
> FROM SP
> GROUP BY PNO
> HAVING COUNT(PNO) > 1;
>
> pno
> -----
> P1
> P2
> P4
> P5
> (4 rows)
>
>
> SELECT PNO
> FROM SP
> GROUP BY PNO
> HAVING COUNT(*) > 1;
>
> 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.

Appreciate your report. Hopefully we can fix it by the 6.3.2 final
release. If not, we will have to remove the feature until 6.4.

--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)