Select the duplicated rows ?

From: Jeong Jae Ick:정재익: <advance(at)advance(dot)sarang(dot)net>
To: pgsql-sql Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Select the duplicated rows ?
Date: 1998-11-30 18:13:41
Message-ID: Pine.LNX.3.96K.981201025652.28898E-100000@advance.sarang.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello pgsql users, I'm having trouble in select statement:

I had one table(test) such as follows:
rowid int primary key,
name char(20)
....

I try to compare the attribute name, and want to select
all duplicated rows that had same name.

I create SELECT statement as follows:
select rowid from test
where name in (select name from test group by name
having 1<count(name));

But, this statement is not executed.
Abnormally terminated with next messages:

test=> select rowid from t where name in (
test-> select name from t group by name having 1<count(name));
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally before or while processing the request.
We have lost the connection to the backend, so further processing is impossible. Terminating.

What's wrong?

Do you have any idea?
Plz, help me. Thans in advance!

==========ooOO /. .\ OOoo======================================
Dept. of Neurosurgery | http://advance.sarang.net
Masan Military Hospital | advances(at)nownuri(dot)net
Korea | advance(at)advance(dot)sarang(dot)net
|
Hanil-Town 201-2007, Yangduk2-Dong| Phone: +82-551-299-2624
Hwoiwon-Gu, Masan-Si, Kyungnam | C.P. : +82-011-871-1959
============OOo./-\.oOO========================================

Browse pgsql-sql by date

  From Date Subject
Next Message Sascha Schumann 1998-11-30 23:00:44 changed SQL in 6.4?
Previous Message Herouth Maoz 1998-11-30 17:09:28 Re: [SQL] Odd characters in inserted data...