RB Smissaert <[EMAIL PROTECTED]>
wrote:
Thanks, that works.
Couldn't get it to work with an alias t1:

delete from table1 t1
where exists (
 select * from table1 t2
 where t1.fieldB = t2.fieldB and t1.OID <> t2.OID

Any what is wrong with that?

It's not a valid syntax for DELETE statement.

Also it is a bit slow despite an index of fieldB. Any ideas how to
speed
this up?

The operation is O(n log n) with an index, O(n^2) without. I don't see how it can be done any faster.

Igor Tandetnik

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to