pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



Message-ID: <359C8C1C.153CE2EB@eclipse.it>
Permalink:  ../359C8C1C.153CE2EB@eclipse.it/
Also on:    postgresql.org/message-id/359C8C1C.153CE2EB@eclipse.it

 · 

reply

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