Hey,
I'm having a very weird thing happening here.
I've had this one table for quite some time, but what I haven't noticed
until now is that only 3 out of 9 indexes seems to be working on it.
OS: Red Hat Linux 6.0 / Linux 2.2.6
Arch: i386
Postgres version: CVS of 6.5 a few days before actual rele
Can someone offer any insight on how the libpq interface compares with
Oracle?
I expect that the embedded SQL in Postgres is reasonably portable to
Oracle (assuming a common SQL subset is used), but I'm interested on
how similar the basic C APIs are?
Thanks
Chris
--
Chris Walmsley (Develop
Try EXCEPT (only in v6.5).
-DEJ
> -Original Message-
> From: Nikolay Mijaylov [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, July 13, 1999 6:41 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Set operator.
>
> I know it is not the same but try this:
>
>
> select table1.va
6.5 has INTERSECT and EXCEPT.
> 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
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
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
