Can you not use your table's primary key value instead?
If you table is created with OIDs you may be able to use those - although I don't know if that this advisable or not since I never use OIDs...
John Sidney-Woollett
Clodoaldo Pinto wrote:
This one must be obvious for most here.
I have a 170 million rows table from which I want to eliminate duplicate "would be" keys and leave only uniques.
I found a query in http://www.jlcomp.demon.co.uk/faq/duplicates.html for the oracle database but can't figure out how to refer to the row id in postgresql:
delete from test where rowid not in (select min(rowid) from test group by a,b);
How to refer to the row id? Any better way to do it?
Regards, Clodoaldo Pinto
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
