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]
-----------------------------------------------------------------------------