Re: Problems with deleting tuples

Have you tried this variation yet:

  delete from zsimp_kopf where zsimp_kopf.rowid in     (select ordered_rids.rid from ordered_rids)

"Stefan Krompaß" " wrote:

> "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> schrieb im Newsbeitrag
> news:3d52d62f$0$8505$cc9e4d1f_at_news.dial.pipex.com...
> > I'm really not sure. how do you populate your ordered rowid table? surely
> > you could just use the where clause for this population for your delete
> > statement.
>
> I've already implemented this "simple" delete:
>
> delete from zsimp_kopf where (
> zsimp_kopf.K2, zsimp_kopf.K3
> ) in (
> select test_zsimp_kopf.K2, test_zsimp_kopf.K3
> from test_zsimp_kopf
> )
>
> Primary key of zsimp_kopf and test_zsimp_kopf are columns K2 and K3
> (test_zsimp_kopf is just a copy of zsimp_kopf with less tuples).
> Now I wonder why
>
> delete from zsimp_kopf where zsimp_kopf.rowid in
> (select ordered_rids.* from ordered_rids)
>
> (with ordered_rids: "create table ordered_rids (rid rowid primary key)
> organization index") results in an error.
>
> Stefan