Today I found a fairly simple problem I didn't know how to solve with PostgreSQL. I ended up with two rows in a table being exactly identical (all columns have the same value). Wanted to keep one of the two identical rows.
Could have deleted both and re-inserted one manually probably. But there's another way, using a "hidden" Postgres column: ctid.
https://stackoverflow.com/questions/6583916/delete-duplicate-rows-from-small-table
@delroth Doesnt `DELETE .... LIMIT 1` also work?
@robryk it just doesn't parse