Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 058CE475914 for ; Fri, 23 Aug 2002 01:28:51 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 6310A474E49 for ; Fri, 23 Aug 2002 01:28:50 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g7N5ShZM017319; Fri, 23 Aug 2002 01:28:48 -0400 (EDT) To: yon@dugem.com Cc: pgsql-sql@postgresql.org Subject: Re: SELECT ... WHERE ... NOT IN (SELECT ...); In-reply-to: <20020823033952.64A443955@sitemail.everyone.net> References: <20020823033952.64A443955@sitemail.everyone.net> Comments: In-reply-to Yon Den Baguse Ngarso message dated "Thu, 22 Aug 2002 20:39:52 -0700" Date: Fri, 23 Aug 2002 01:28:43 -0400 Message-ID: <17318.1030080523@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/318 X-Sequence-Number: 9164 Yon Den Baguse Ngarso writes: > I'm confused, the result should not 0 rows, right? Not what I get: regression=# create table tbl1(eventid int); CREATE TABLE -- load data regression=# SELECT eventid FROM tbl1; eventid --------- 119064 119064 60116 16082 16082 16303 16082 92628 92628 60083 (10 rows) regression=# create table tbl2(eventid int); CREATE TABLE -- load data regression=# SELECT eventid FROM tbl2; eventid --------- 123989 123989 123989 16134 16134 16368 16134 92685 92685 60115 (10 rows) regression=# SELECT eventid FROM tbl1 WHERE eventid NOT IN (SELECT eventid FROM tbl2); eventid --------- 119064 119064 60116 16082 16082 16303 16082 92628 92628 60083 (10 rows) I think there must be something you didn't tell us... regards, tom lane