19.12.2012 | Hans-Jürgen SchönigRemoving duplicates in PostgreSQL
Today somebody has asked me how to remove duplicates which accidentally made it into a table. The problem is: A normal DELETE won’t do because you would delete both values – not just the one which is in there twice. To solve the problem you have to use a “secret” column called “ctid”. The “ctid” […]
Read more