[GENERAL] Union & Nested queries

[Nelio Alves Pereira Filho]

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