RE: [GENERAL] Query bombed: why?

2000-05-09 Thread Jeff Eckermann
--Original Message- From: Tom Lane [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 09, 2000 12:35 PM To: Jeff Eckermann Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Query bombed: why? Jeff Eckermann [EMAIL PROTECTED] writes: After about 25 minutes of running a query with a "w

Re: [GENERAL] Query bombed: why?

2000-05-09 Thread Tom Lane
Jeff Eckermann [EMAIL PROTECTED] writes: I was expecting not much more than 50 rows to be returned, with an absolute maximum of 70. I was trying to simulate an outer join by using the "where not exists" clause, so that I would get back my full list of 70 and be able to see the unmatched