group by and count(*) behaviour in 8.3

Поиск
Список
Период
Сортировка
От Edoardo Panfili
Тема group by and count(*) behaviour in 8.3
Дата
Msg-id 477B5747.7080608@aspix.it
обсуждение исходный текст
Ответы Re: group by and count(*) behaviour in 8.3  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Список pgsql-general
I am using this query in 8.3beta4 (compiled from source) in MacOS X 10.5.1

SELECT webName,count(*) FROM contenitore NATURAL JOIN cartellino WHERE
contenitore.tipo='e' GROUP BY webName;

this is the result
                       webName                      | count
--------------------------------------------------+-------
   test palermo                                     | 36679
   Herbarium Camerinensis - CAME                    | 36679
   Herbarium Universitatis Aeserniae - IS           | 36679
   Herbarium Universitatis Civitatis Perusii - PERU | 36679
   Herbarium Anconitanum - ANC                      | 36679
   Test database - São Paulo                        | 36679
   Herbarium Universitatis Genuensis - GE           | 36679
   Herbarium Universitatis Senensis - SIENA         | 36679
   Segnalazioni Siena                               | 36679
   Herbarium Aquilanum - AQUI                       | 36679
(10 rows)

but 36679 is the total number of row of the table.
The same query in 8.1.4 retrieves the aspected result (the number of
elements for each webName).

Is this a bug or a change in the semantic of SQL?

thank you
Edoardo

--
Jabber: edoardopa@talk.google.com
tel: 075 9142766

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

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Can't make backup
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: Need help requiring uniqueness in text columns