Re: SELECT ... WHERE ... NOT IN (SELECT ...);

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: yon(at)dugem(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SELECT ... WHERE ... NOT IN (SELECT ...);
Date: 2002-08-23 05:28:43
Message-ID: 17318.1030080523@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Yon Den Baguse Ngarso <yon(at)dugem(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Björn Lundin 2002-08-23 06:53:46 Re: speeding up \d commands.
Previous Message Rajesh Kumar Mallah. 2002-08-23 04:40:50 speeding up \d commands.