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@candle.pha.pa.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)

From maillist Mon Apr 13 11:03:12 1998
Received: (from maillist@localhost)
by candle.pha.pa.us (8.8.5/8.8.5) id LAA17347
for maillist; Mon, 13 Apr 1998 11:03:11 -0400 (EDT)
From: Bruce Momjian <maillist>
Message-Id: <199804131503.LAA17347@candle.pha.pa.us>
Subject: Re: [HACKERS] error on HAVING clause
To: sferac@proxy.bazzanese.com (Jose' Soares Da Silva)
Date: Thu, 9 Apr 1998 11:40:45 -0400 (EDT)
Cc: pgsql-bugs@postgreSQL.org, pgsql-hackers@postgreSQL.org
In-Reply-To: <Pine.LNX.3.96.980409171024.1506C-100000@proxy.bazzanese.com>
from "Jose' Soares Da Silva" at Apr 9, 98 05:11:25 pm
X-Mailer: ELM [version 2.4 PL25]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Sender: maillist
Status: OR

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@candle.pha.pa.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)