2007/9/19, Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>:
(...)
> 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