Re: deletion of records

Patrick Welche a écrit:
> On Fri, Jul 12, 2002 at 09:38:39AM +0200, frbn wrote:
>
>>DELETE FROM custinfo,custinfotemp
>>WHERE
>>    custinfo.UserID=custinfotemp.userid
>>    and
>>    custinfotemp.updateStatus='D'
>>;
>>should avoid the 2.10^6 selects
>
>
> Won't that delete rows from custinfotemp too?
>
> Patrick

no, as this is syntaxically incorrect. oops

I meant:

delete from custinfo
where custinfo.UserID=custinfotemp.userid
and
custinfotemp.updateStatus='D';

---------------------------------------------
    explain delete from t1 where t1.c1 = t2.c1;

Merge Join  (cost=200000139.66..200000164.66 rows=10000 width=14)
   ->  Sort  (cost=100000069.83..100000069.83 rows=1000 width=10)
         ->  Seq Scan on t1  (cost=100000000.00..100000020.00 rows=1000 width=10)
   ->  Sort  (cost=100000069.83..100000069.83 rows=1000 width=4)
         ->  Seq Scan on t2  (cost=100000000.00..100000020.00 rows=1000 width=4)


ps: An interesting notice in the errlog:

    NOTICE:  Adding missing FROM-clause entry for table "t2"

I don't know how to remove this *non*enoying notice :)