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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Release notes
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] error on HAVING clause