From: | "Meskes, Michael" <meskes(at)topsystem(dot)de> |
---|---|
To: | "'Zeugswetter Andreas SARZ'" <Andreas(dot)Zeugswetter(at)telecom(dot)at>, "'pgsql-hackers(at)hub(dot)org'" <pgsql-hackers(at)hub(dot)org> |
Subject: | RE: [HACKERS] Subselects and NOTs |
Date: | 1998-02-19 08:58:07 |
Message-ID: | 11720CEF3853D011AC0C00A024B7A9E1112582@EINSTEIN |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Exactly the same with the latest Oracle7 version.
Michael
--
Dr. Michael Meskes, Project-Manager | topsystem Systemhaus GmbH
meskes(at)topsystem(dot)de | Europark A2, Adenauerstr. 20
meskes(at)debian(dot)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(dot)Zeugswetter(at)telecom(dot)at]
> Sent: Wednesday, February 18, 1998 6:33 PM
> To: 'pgsql-hackers(at)hub(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Meskes, Michael | 1998-02-19 09:16:46 | RE: [HACKERS] libpgtcl undefined symbol error with pgaccess-0.76 |
Previous Message | Meskes, Michael | 1998-02-19 08:51:25 | RE: New ecgp code problem. |