From: | David Raymond <David(dot)Raymond(at)tomtom(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | RE: BUG #16031: Group by returns duplicate groups |
Date: | 2019-09-30 18:21:33 |
Message-ID: | VI1PR07MB602902D7CE166594FC1EF5AE87820@VI1PR07MB6029.eurprd07.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
All the lc_* settings are en-US, and server_encoding is UTF8.
-----Original Message-----
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Sent: Monday, September 30, 2019 2:17 PM
To: David Raymond <David(dot)Raymond(at)tomtom(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16031: Group by returns duplicate groups
PG Bug reporting form <noreply(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | David Raymond | 2019-09-30 21:48:59 | RE: BUG #16031: Group by returns duplicate groups |
Previous Message | Tom Lane | 2019-09-30 18:17:14 | Re: BUG #16031: Group by returns duplicate groups |