Thread: Union & Nested queries

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

Nelio Alves Pereira Filho <nelio@ifx.com.br> writes:
> 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"

Not supported currently.  7.1 will handle it...

            regards, tom lane