Postgres Pro
Downloads
Home   >   mailing lists

Fwd: Need efficient way to remove (almost) duplicate rows from a table - Mailing list pgsql-general

From Michael Nolan
Subject Fwd: Need efficient way to remove (almost) duplicate rows from a table
Date
Msg-id CAOzAquLccUsMTnrVFuXXw_xTdJN7pEtBu-_S8jn5-etpwj75mQ@mail.gmail.com
Whole thread Raw
In response to Need efficient way to remove (almost) duplicate rows from a table  (David Gauthier <dfgpostgres@gmail.com>)
List pgsql-general
Tree view 
I'm not clear which rows are duplicates.

It looks like limb_id, branch_id and twig_id make up a unique key.

If there was a row (2, 2, 7,103.7) would it be a duplicate of rows
(1,1,2,103.7) and (1,1,3,103.7)?
--
MIke Nolan

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Inheritance in PostgreSQL
Next
From: Hafeez Rahim
Date:
Subject: Re: Index based search have issues with 11.20