From: | Stuart Rison <stuart(at)ludwig(dot)ucl(dot)ac(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | [GENERAL] Set operator. |
Date: | 1999-07-13 10:18:42 |
Message-ID: | v04020a04b3b0c207de95@[128.40.242.190] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Nikolay Mijaylov | 1999-07-13 11:40:36 | Re: [GENERAL] Set operator. |
Previous Message | Claudio R Zamana | 1999-07-12 21:56:18 | subscribe pgsql-general |