Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id A3B23475EFA
	for <pgsql-sql@postgresql.org>; Fri, 23 Aug 2002 03:55:35 -0400 (EDT)
Received: from omta01.mta.everyone.net (sitemail3.everyone.net
	[216.200.145.37])
	by postgresql.org (Postfix) with ESMTP id 8BF7B475BED
	for <pgsql-sql@postgresql.org>; Fri, 23 Aug 2002 03:55:33 -0400 (EDT)
Received: from sitemail.everyone.net (dsnat [216.200.145.62])
	by omta01.mta.everyone.net (Postfix) with ESMTP
	id 7ECCD1C4405; Fri, 23 Aug 2002 00:55:34 -0700 (PDT)
Received: by sitemail.everyone.net (Postfix, from userid 99)
	id 689143959; Fri, 23 Aug 2002 00:55:34 -0700 (PDT)
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0
X-Mailer: MIME-tools 5.41 (Entity 5.404)
Date: Fri, 23 Aug 2002 00:55:34 -0700 (PDT)
From: Yon Den Baguse Ngarso <yon@dugem.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: SELECT ... WHERE ... NOT IN (SELECT ...);
Reply-To: yon@dugem.com
X-Originating-Ip: [202.152.11.250]
Message-Id: <20020823075534.689143959@sitemail.everyone.net>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/320
X-Sequence-Number: 9166

That's way i'm confuse.
I'm using postgresql-7.1.3

I did the same action like you do.
Am i missing something?     

TIA,
Yon

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
>Yon Den Baguse Ngarso <yon@dugem.com> 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
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org

_____________________________________________________________
Get yourname@dugem.com at http://www.dugem.com

_____________________________________________________________
Promote your group and strengthen ties to your members with email@yourgroup.org by Everyone.net  http://www.everyone.net/?btn=tag