Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16031: Group by returns duplicate groups - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #16031: Group by returns duplicate groups
Date
Msg-id 18850.1569867434@sss.pgh.pa.us
Whole thread Raw
In response to BUG #16031: Group by returns duplicate groups  (PG Bug reporting form <noreply@postgresql.org>)
Responses RE: BUG #16031: Group by returns duplicate groups
List pgsql-bugs
Tree view 
PG Bug reporting form <noreply@postgresql.org> writes:
> I have a large table which I'm running a query on, grouping on a single
> field, and returning only that 1 field, filtered with a HAVING clause. The
> results that I'm getting back however contain a duplicate entry for one of
> the returned values, which I believe should never be able to happen.

That seems quite weird.  What LC_COLLATE/LC_CTYPE settings are you using?

            regards, tom lane

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16031: Group by returns duplicate groups
Next
From: David Raymond
Date:
Subject: RE: BUG #16031: Group by returns duplicate groups