Skip site navigation (1) Skip section navigation (2)

BUG #1359: there is a problem in "SELECT ....GROUP BY"

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: (view raw, whole thread or download thread mbox)
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"

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),
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)

pgsql-bugs by date

Next:From: Tran Duc KhoaDate: 2004-12-27 10:08:14
Subject: BUG #1360: Use PostgreSQL OLE DB Provider in VS.NET 2003
Previous:From: John SummerfieldDate: 2004-12-26 12:11:53
Subject: PostgreSQL 8.0.0 Release Candidate 2 announcement

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group