bug on Subselect with GROUP BY clause

Поиск
Список
Период
Сортировка
От Sferacarta Software
Тема bug on Subselect with GROUP BY clause
Дата
Msg-id 11620.990104@bo.nettuno.it
обсуждение исходный текст
Список pgsql-hackers
Hi all,

Seems there's a bug using GROUP BY not on select list on subselects:

SELECT city, AVG(account)       FROM customer       GROUP BY city       HAVING AVG(account) >= ALL       (SELECT
city,AVG(account)              FROM customer group by city               );
 
ERROR:  parser: Subselect has too many or too few fields.

Instead the following does work:

SELECT city, AVG(account)            FROM customer            GROUP BY city;
city    |avg
--------+---
Chicago | 10
Dallas  | 60
New York| 50
(3 rows)

SELECT AVG(account)      FROM customer      GROUP BY city;
avg
---106050
(3 rows)

-Jose'-




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Sferacarta Software
Дата:
Сообщение: int4 range
Следующее
От: Sferacarta Software
Дата:
Сообщение: too many ANDs ?