Postgres Pro
Downloads
Home   >   mailing lists

Re: How to delete completely duplicate rows - Mailing list pgsql-general

From Merlin Moncure
Subject Re: How to delete completely duplicate rows
Date
Msg-id CAHyXU0xfa6kSbtGenFTZna6a2UT9nQoO65TV=b1jKGY+QZEHvA@mail.gmail.com
Whole thread Raw
In response to Re: How to delete completely duplicate rows  ("Janek Sendrowski" <janek12@web.de>)
List pgsql-general
Tree view 
On Thu, Jan 2, 2014 at 4:33 AM, Janek Sendrowski <janek12@web.de> wrote:
> Thanks!
> It's working

you can do it without listing columns via:

select *, row_number() over(partition by c) from c;

emphasis on 'partition by c'.

merlin

pgsql-general by date:

Previous
From: Abdul Sayeed
Date:
Subject: Re: How to list and describe tables in psql???
Next
From: "john.tiger"
Date:
Subject: json query problem