On Wed, 2007-09-19 at 11:05 +0100, Filip Rembiałkowski wrote:
> 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)
>
> and
> DELETE FROM ... ONLY parent ...
Here's the obigatory Ooohhh or the simpson's "Doh!"
Let me re-try this and see how it goes.
Many thanks for the Ooo... ( I feel like the "green aliens" in Toy
Story)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
