intersec problem - Mailing list pgsql-sql

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