RE: [HACKERS] Subselects and NOTs

Exactly the same with the latest Oracle7 version.

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

> -----Original Message-----
> From:    Zeugswetter Andreas SARZ [SMTP:Andreas.Zeugswetter@telecom.at]
> Sent:    Wednesday, February 18, 1998 6:33 PM
> To:    'pgsql-hackers@hub.org'
> Subject:    Re: [HACKERS] Subselects and NOTs
>
> This is what I did:
>     create table a (a int, a1 char(8));
>     create table b (b int);
>     insert into a values (1, 'one');
>     insert into a values (NULL, 'null');
>
>
> and this is what I got from Informix:
> > select * from a where a not in (select * from b);
>           a a1
>           1 one
>             null
> 2 row(s) retrieved.
> >  select * from a where not (a in (select * from b));
>           a a1
>           1 one
>             null
> 2 row(s) retrieved.
> > select * from a where not a in (select * from b);
>           a a1
>           1 one
>             null
> 2 row(s) retrieved.
> > select * from a where a<>(select * from b);
>           a a1
> No rows found.
> > select * from a where a=(select * from b);
>           a a1
> No rows found.
>
> Andreas