On Fri, 2010-01-15 at 13:55 +1300, Ravi Chemudugunta wrote:
> I cannot quite understand this; Are the contents of the IN query
> worked out ONCE per outer query and therefore become invalid when
> DELETE comes along and changes items that were part of the set ? (for
> e.g.)
The command itself gets
There are two ways of deleting things,
DELETE FROM WHERE PK IN ( ...SET... );
DELETE FROM USING
WHERE AND ;
I am deleting from a table where the rows are inter-related (it is a
tree); using the first version with IN, it does not delete all rows;
there is a trigger that rearranges the rows wh