I had one table(test) such as follows:
rowid int primary key,
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
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.
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
pgsql-sql by date
|Next:||From: pierre||Date: 1998-12-01 01:22:47|
|Subject: Re: [SQL] changed SQL in 6.4?|
|Previous:||From: root||Date: 1998-12-01 00:21:11|