Re: [SQL] need some help with a delete statement

[Matthew Hixson]

Thanks for all your help, Scott.  A friend of mine whipped out this 
script which runs a lot faster than trying to use the original query I 
posted.
  -M@

begin;
create temporary table cart_temp as select distinct a.cart_id,
a.cart_cookie from v_carts a, v_cart_contents b where a.cart_id = 
b.cart_id;
delete from v_carts;
insert into v_carts (cart_id, cart_cookie) select cart_id, cart_cookie
from cart_temp order by cart_id;
drop table cart_temp;
commit;
vacuum analyze verbose v_carts;
reindex table v_carts;

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])