2007/9/19, Ow Mun Heng <[EMAIL PROTECTED]>:
(...)
> 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)
and
DELETE FROM ... ONLY parent ...
--
Filip Rembiałkowski
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
