In response to Edward W. Rouse :
> Solved. Because this is a 7.4 version and we used with oids by default, I
> can use the oids instead of the ctid to remove the duplicates.
Yeah, that's right ;-)
Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr:
Sent: Tuesday, August 10, 2010 4:43 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Duplicate rows
I am trying to test this but get an error.
select ctid, * from test where id < 300 order by id, ctid;
ERROR: could not identify an ordering operator for type tid
HINT: Use an expli
Of Andreas Kretschmer
Sent: Tuesday, August 10, 2010 3:45 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Duplicate rows
Edward W. Rouse wrote:
> Is there any way to remove a duplicate row from a table? Not my db but I
have
> to work with it. On version 7.4 right now.
>
How to select the
A few ways to do this:
http://www.sql-ex.ru/help/select17.php
> Is there any way to remove a duplicate row from a table? Not my db but I have
> to work with it. On version 7.4 right now.
> Edward W. Rouse
> Comsquared System, Inc.
> 770-734-5301
>
--
Sent via pgsql-sql mailing list (pgsql-sql
Edward W. Rouse wrote:
> Is there any way to remove a duplicate row from a table? Not my db but I have
> to work with it. On version 7.4 right now.
>
How to select the right records?
You can try to use the ctid-column, see my simple example:
test=# select * from dups ;
i
---
1
1
1
2
2
Is there any way to remove a duplicate row from a table? Not my db but I
have to work with it. On version 7.4 right now.
Edward W. Rouse
Comsquared System, Inc.
770-734-5301
