intersec problem

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(at)eclipse(dot)it
Point of Presence I.NET URL : http://www.eclipse.it