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

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