Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 624872E2FD1
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 10 Jan 2008 16:15:59 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 95665-06 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 10 Jan 2008 16:15:57 -0400 (AST)
Received: from wa-out-1112.google.com (wa-out-1112.google.com
 [209.85.146.180])
	by postgresql.org (Postfix) with ESMTP id A112D2E2ECC
	for <pgsql-performance@postgresql.org>;
	Thu, 10 Jan 2008 16:15:55 -0400 (AST)
Received: by wa-out-1112.google.com with SMTP id m38so1420975waf.5
	for <pgsql-performance@postgresql.org>;
	Thu, 10 Jan 2008 12:15:53 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	bh=5mbMz9l7SJ6h6rb7satifCwLRr7vACXE1NAIc3zHhTM=;
	b=XAAGu6HNhW1/4LBFJzOTU3xSZ2sEqvi60+HTijLzadq9Mkk2bPopfGQcPZlqHXBfucTvTQtk283jK/fbIT6ZyDQf5+1qo9V62hZ1J8b3yrhl38LExUWtyIoQ9dLAc5JWmXMxbfddNl2tUOevj7fHuqRckFPZrcUT1L37B5fA3sk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=B9w0jJGMwKDKXSne77wYuM3/7LVUfNNIc41GXMKM/+9WVMQLEypIWimOHXTL9mHZ6s14GaaA6PmQfXJfvCzmXS3QxZ5iCbSUUy/+eZLxd16PhwRKnpOm41h1FgdiAkplnT2KI3IvyQDRGeY+mmdapqn1vAKTLQNUHrkK4nncLoA=
Received: by 10.115.110.6 with SMTP id n6mr2680014wam.92.1199996153592;
	Thu, 10 Jan 2008 12:15:53 -0800 (PST)
Received: by 10.115.78.10 with HTTP; Thu, 10 Jan 2008 12:15:53 -0800 (PST)
Message-ID: <4a5f56930801101215l5ae2d5bdk2db4f1873e0789ca@mail.gmail.com>
Date: Thu, 10 Jan 2008 15:15:53 -0500
From: "S Golly" <gollykai@gmail.com>
To: pgsql-performance@postgresql.org
Subject: not exists clause
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_47194_27801340.1199996153585"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200801/56
X-Sequence-Number: 28295

------=_Part_47194_27801340.1199996153585
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I cannot get the "not exists" clause of ANSI SQL to execute correctly.
select t.col11, t.col1... from table1 t where not exists (select 1 from
table2 where col2 = t.col1);
table1 has 40M + rows. if that matters.

OS is FreeBSD 6.2, postgresql version 8.2.6

Is it not supported or a bug ?
thank you for your support.

------=_Part_47194_27801340.1199996153585
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>I cannot get the &quot;not exists&quot; clause of ANSI SQL to execute correctly.</div>
<div>select t.col11, t.col1... from table1 t where not exists (select 1 from table2 where col2 = t.col1);</div>
<div>table1 has 40M + rows. if that matters.</div>
<div>&nbsp;</div>
<div>OS is FreeBSD 6.2, postgresql version 8.2.6</div>
<div>&nbsp;</div>
<div>Is it not supported or a bug ?</div>
<div>thank you for your support.</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</div>

------=_Part_47194_27801340.1199996153585--