From: | "jingold chen" <jingold_chen(at)hotmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1359: there is a problem in "SELECT ....GROUP BY" |
Date: | 2004-12-26 15:55:32 |
Message-ID: | 200412261555.iBQFtWKR025045@developer.pgadmin.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1359
Logged by: jingold chen
Email address: jingold_chen(at)hotmail(dot)com
PostgreSQL version: 8.0
Operating system: window xp home edition
Description: there is a problem in "SELECT ....GROUP BY"
Details:
I have install a postgresql 8.0 RC2 for window.
And Create a database with "Unicode"
But I send a query at "pgAdminIII 1.2":
"select recie_man,count(id) from public.case_table
group by 1 order by 2"
It return a recordset with duplicate record.
-----------
the table(case_table) definition:
CREATE TABLE public.case_table
(
id int4 NOT NULL,
caseclass char(1),
linkman char(24),
emailaddr char(32),
address text,
phone char(16),
recie_man char(64),
) WITH OIDS;
I don't know what worry in it.
Is it the postgresql 8.0 bug?
I have do the same test in postgresql 7.4 for linux
and gain the right result (It return a recordset without duplicate)
From | Date | Subject | |
---|---|---|---|
Next Message | Tran Duc Khoa | 2004-12-27 10:08:14 | BUG #1360: Use PostgreSQL OLE DB Provider in VS.NET 2003 |
Previous Message | John Summerfield | 2004-12-26 12:11:53 | PostgreSQL 8.0.0 Release Candidate 2 announcement |