error on HAVING clause
От | Jose' Soares Da Silva |
---|---|
Тема | error on HAVING clause |
Дата | |
Msg-id | Pine.LNX.3.96.980409171024.1506C-100000@proxy.bazzanese.com обсуждение исходный текст |
Ответы |
Re: [HACKERS] error on HAVING clause
|
Список | pgsql-hackers |
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: --------------------------------------------------------------------- ??
В списке pgsql-hackers по дате отправления: