Horton

Re: [HACKERS] Subselects are in CVS...

Michael Meskes <meskes@topsystem.de>

View thread
From: Michael Meskes <meskes@topsystem.de>
To: vadim@sable.krasnoyarsk.su (Vadim B. Mikheev)
Cc: pgsql-hackers@postgresql.org (PostgreSQL Hacker)
Date: 1998-02-13T13:53:29Z
Lists: pgsql-hackers 
Vadim B. Mikheev writes:
> 5. I need in advice: if subquery introduced with NOT IN doesn't return
>    any tuples then qualification is failed, yes ?

Do you mean something like this:

select * from table1 where x not in (select x from table2)

table1.x: a,b

table2.x is empty

The correct answer IMO is 'a,b' in this case.

Michael

-- 
Dr. Michael Meskes, Project-Manager    | topsystem Systemhaus GmbH
meskes@topsystem.de                    | Europark A2, Adenauerstr. 20
meskes@debian.org                      | 52146 Wuerselen
Go SF49ers! Go Rhein Fire!             | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux!                  | Fax: (+49) 2405/4670-10