From: | "Nikolay Mijaylov" <nmmm(at)nsi(dot)bg> |
---|---|
To: | <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Set operator. |
Date: | 1999-07-13 11:40:36 |
Message-ID: | 001b01becd24$952e2a60$ce2a18c3@skillbrokers.bg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I know it is not the same but try this:
select table1.value1 from table1 where table1.value1 not in (select
table2.value2 from table2)
well im never try this to this moment..... :)
but u can
nmmm.hypermart.net
w3.nsi.bg/linux
www.nsi.bg/nmmm
----- Original Message -----
From: Stuart Rison <stuart(at)ludwig(dot)ucl(dot)ac(dot)uk>
To: <pgsql-general(at)postgreSQL(dot)org>
Sent: 13 Þëè 1999 ã. 13:18
Subject: [GENERAL] Set operator.
> Dear all,
>
> What set operators other then UNION do PG have?
>
> In particular, I am interested in the MINUS or equivalent operator. e.g
>
> table1:
>
> value1
> 1
> 2
> 3
> 4
> 5
> 6
> 7
> 8
> 9
>
> table2:
>
> value2
> 1
> 3
> 5
> 7
> 9
>
> SELECT table1.value1 FROM table1 MINUS table2.value2 FROM table2;
>
> result:
> 2
> 4
> 6
> 8
>
> I have PG 6.4.0 so please specify what version of PG might have this
> functionality... also, can anybody offer hints as to how to implement such
> functionality if necessary?
>
> Regards,
>
> Stuart.
>
> +-------------------------+--------------------------------------+
> | Stuart Rison | Ludwig Institute for Cancer Research |
> +-------------------------+ 91 Riding House Street |
> | Tel. (0171) 878 4041 | London, W1P 8BT, UNITED KINGDOM. |
> | Fax. (0171) 878 4040 | stuart(at)ludwig(dot)ucl(dot)ac(dot)uk |
> +-------------------------+--------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-07-13 16:58:43 | Re: [GENERAL] Set operator. |
Previous Message | Stuart Rison | 1999-07-13 10:18:42 | [GENERAL] Set operator. |