From: | ocie(at)paracel(dot)com |
---|---|
To: | meskes(at)topsystem(dot)de (Meskes, Michael) |
Cc: | Andreas(dot)Zeugswetter(at)telecom(dot)at, pgsql-hackers(at)hub(dot)org |
Subject: | Re: [HACKERS] Subselects and NOTs |
Date: | 1998-02-19 18:21:58 |
Message-ID: | 9802191821.AA02956@dolomite.paracel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Meskes, Michael wrote:
>
> Exactly the same with the latest Oracle7 version.
I also get the same results with Sybasem, with one interesting
exception. Sybase will not let me select * in a subquery! It gives
me the following:
The symbol '*' can only be used for a subquery select list when the subquery is
introduced with EXISTS or NOT EXISTS.
changing this to "select b from b" seems to work though.
Ocie
>
> 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 | The Hermit Hacker | 1998-02-19 18:34:01 | Re: [HACKERS] Solution to the pg_user passwd problem !?? (c) |
Previous Message | Bruce Momjian | 1998-02-19 18:20:06 | Re: AW: [HACKERS] Solution to the pg_user passwd problem !?? (c) |