2007/9/19, Ow Mun Heng <Ow.Mun.Heng@xxxxxxx>: (...) > simulate a delete> => delete from parent where id in (select id from child);> DELETE 6>> => select * from parent;> id | data1> ----+---------> 2 | parent2> 3 | parent3> 4 | parent4>> => select * from child;> id | data1> ----+-------> (0 rows)>Yes. You can however try SELECT FROM ... ONLY parent ...(that's what I used in example) andDELETE FROM ... ONLY parent ... -- Filip Rembiałkowski ---------------------------(end of broadcast)---------------------------TIP 1: 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
