Thank you so much, I guess my sql skills need sharpening. I have been trying
all night to find out how to do a join with delete. I thought I needed to
mention t2 in the from clause, but that didn't work. This worked great.
Sally
----- Original Message -----
From: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>
To: <sar(at)northelectriccompany(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, November 30, 2004 10:38 AM
Subject: Re: [GENERAL] delete with index scan