Received: from relay.eclipse.it (root@ns.eclipse.it [194.177.121.100]) by hub.org (8.8.8/8.7.5) with ESMTP id DAA08099 for ; Fri, 3 Jul 1998 03:47:19 -0400 (EDT) Received: from eclipse.it (argon.eclipse.it [194.177.121.18]) by relay.eclipse.it (8.8.7/8.8.8) with ESMTP id JAA09281 for ; Fri, 3 Jul 1998 09:46:16 +0200 Sender: tiziano@eclipse.it Message-ID: <359C8C1C.153CE2EB@eclipse.it> Date: Fri, 03 Jul 1998 09:45:32 +0200 From: Tiziano Tresanti Organization: Eclipse S.p.A. X-Mailer: Mozilla 4.04 [en] (X11; I; SunOS 5.6 sun4u) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: intersec problem Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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