Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding PRIMARY KEY: Table contains duplicated values - Mailing list pgsql-general

From Alexander Farber
Subject Re: Adding PRIMARY KEY: Table contains duplicated values
Date
Msg-id CAADeyWhBjv9BL97ZHMf_nzm2x3NytXi_qyNnykOFZ14KHT3nRQ@mail.gmail.com
Whole thread Raw
In response to Re: Adding PRIMARY KEY: Table contains duplicated values  (Alexander Farber <alexander.farber@gmail.com>)
Responses Re: Adding PRIMARY KEY: Table contains duplicated values  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: Adding PRIMARY KEY: Table contains duplicated values  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view 
Trying to delete the older of the duplicated pairs:

# SELECT id, author, count(1), max(stamp) as maxx
  FROM pref_rep
GROUP BY id, author
HAVING count(1) >1 and stamp < maxx;
ERROR:  column "maxx" does not exist
LINE 4: HAVING count(1) >1 and stamp < maxx;
                                       ^

On Mon, Feb 4, 2013 at 3:36 PM, Alexander Farber
<alexander.farber@gmail.com> wrote:
>>> http://stackoverflow.com/questions/14688523/adding-primary-key-table-contains-duplicated-values
>

pgsql-general by date:

Previous
From: Kirk Wythers
Date:
Subject: partial time stamp query
Next
From: Kirk Wythers
Date:
Subject: partial time stamp query