From: Tiziano Tresanti <tiziano@eclipse.it>
To: pgsql-sql@postgresql.org
Subject: intersec problem
Date: Fri, 03 Jul 1998 09:45:32 +0200
Message-ID: <359C8C1C.153CE2EB@eclipse.it> (raw)
Hi
I'm Tiziano
I would like to know, if the lastest version of postgres 6.3.2,
is able to do intersect function and/or subquery?
If it isn't please give me an alternative solution.
i have tried this command
>> select * from TABLE1 intersect select * from TABLE2; <<
is it syntax correct?
psql give me this error:
>> ERROR: parser: parse error at or near "select" <<
I have see that if I use this command
>> select * from TABLE1 intersect ;
It work .
Many thanks!
TT
--
Tresanti Tiziano - Eclipse S.p.A. Phone : +39 0464 42 37 55
Largo Posta, 5 Fax : +39 0464 42 09 02
I-38068 Rovereto (TN), Italy E-Mail : tiziano@eclipse.it
Point of Presence I.NET URL : http://www.eclipse.it
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: tiziano@eclipse.it
Subject: Re: intersec problem
In-Reply-To: <359C8C1C.153CE2EB@eclipse.it>
References: <359C8C1C.153CE2EB@eclipse.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox