group by and count(*) behaviour in 8.3

From: Edoardo Panfili <edoardo(at)aspix(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: group by and count(*) behaviour in 8.3
Date: 2008-01-02 09:20:07
Message-ID: 477B5747.7080608@aspix.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)talk(dot)google(dot)com
tel: 075 9142766

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2008-01-02 09:23:46 Re: Need help requiring uniqueness in text columns
Previous Message Albe Laurenz 2008-01-02 07:48:11 Re: Can't make backup