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” […]