Postgres Pro
Downloads
Home   >   mailing lists

how to remove the duplicate records from a table - Mailing list pgsql-general

From Yi Zhao
Subject how to remove the duplicate records from a table
Date
Msg-id 1223361419.3769.6.camel@localhost.localdomain
Whole thread Raw
In response to Federated Server  (searchelite <searchelite@gmail.com>)
Responses Re: how to remove the duplicate records from a table  ("Peter Childs" <peterachilds@gmail.com>)
Re: how to remove the duplicate records from a table  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view 
I have a table contains some duplicate records, and this table create
without oids, for example:
 id | temp_id
----+---------
 10 |       1
 10 |       1
 10 |       1
 20 |       4
 20 |       4
 30 |       5
 30 |       5
I want get the duplicated records removed and only one is reserved, so
the results is:
10 1
20 4
30 5

I know create a temp table will resolve this problem, but I don't want
this way:)

can someone tell me a simple methold?

any help is appreciated,

thanks,

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: Installation on CentOS 5.2 (readline trouble)
Next
From: "Henry Combrinck"
Date:
Subject: Re: Looping through cursor row batches