To report any other bug, fill out the form below and e-mail it to
pgsql-bugs@postgresql.org.
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Jose' Soares
Your email address : sferac@bo.nettuno.it
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium
Operating System (example: Linux 2.0.26 ELF) : Linux 2.0.31 Elf
PostgreSQL version (example: PostgreSQL-6.1) : PostgreSQL-snapshot april 6, 1998
Compiler used (example: gcc 2.7.2) : gcc 2.7.2.1
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.
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
??
