Union & Nested queries - Mailing list pgsql-general

From Nelio Alves Pereira Filho
Subject Union & Nested queries
Date
Msg-id 3A0C0A5B.B81D2689@ifx.com.br
Whole thread Raw
Responses Re: Union & Nested queries  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I tried to do the following query, but it doesn't work.

IFX=> select 1 IN (SELECT 1 UNION SELECT 2);
ERROR:  parser: parse error at or near "union"

Are there and syntax error? What is wrong about that??

Thanks

--
Nelio Alves Pereira Filho
IFX Networks
Sao Paulo / Brazil




pgsql-general by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: strange behvaviour in join? BUG in 7.02?
Next
From: Tom Lane
Date:
Subject: Re: strange behvaviour in join? BUG in 7.02?