error on HAVING clause

From: "Jose' Soares Da Silva" <sferac(at)proxy(dot)bazzanese(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: error on HAVING clause
Date: 1998-04-09 17:11:25
Message-ID: Pine.LNX.3.96.980409171024.1506C-100000@proxy.bazzanese.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

To report any other bug, fill out the form below and e-mail it to
pgsql-bugs(at)postgresql(dot)org(dot)

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Jose' Soares
Your email address : sferac(at)bo(dot)nettuno(dot)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:
---------------------------------------------------------------------

??

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Gould 1998-04-09 18:34:00 Re: [HACKERS] Everything leaks; How it mm suppose to work?
Previous Message Bruce Momjian 1998-04-09 15:40:45 Re: [HACKERS] error on HAVING clause