Postgres Pro
Downloads
Home   >   mailing lists

SELECT ... WHERE ... NOT IN (SELECT ...); - Mailing list pgsql-sql

From Yon Den Baguse Ngarso
Subject SELECT ... WHERE ... NOT IN (SELECT ...);
Date
Msg-id 20020823033952.64A443955@sitemail.everyone.net
Whole thread Raw
Responses Re: SELECT ... WHERE ... NOT IN (SELECT ...);  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
opennms=# SELECT eventid FROM tbl1;eventid
--------- 119064 119064  60116  16082  16082  16303  16082  92628  92628  60083
(10 rows)


opennms=# SELECT eventid FROM tbl2;eventid
--------- 123989 123989 123989  16134  16134  16368  16134  92685  92685  60115
(10 rows)


opennms=# SELECT eventid FROM tbl1 WHERE eventid NOT IN (SELECT eventid FROM tbl2);
eventid
---------
(0 rows)

I'm confused, the result should not 0 rows, right?

Pls Help. Am I missing something?

TIA.

_____________________________________________________________
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

pgsql-sql by date:

Previous
From: imtiaz sm
Date:
Subject: Re: BITMAP INDEXES...
Next
From: "Rajesh Kumar Mallah."
Date:
Subject: speeding up \d commands.