Union & Nested queries

Started by Nelio Alves Pereira Filhoover 25 years ago2 messagesgeneral

nelio@ifx.com.br

over 25 years ago

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

tgl@sss.pgh.pa.us

over 25 years ago

In reply to: Nelio Alves Pereira Filho (#1)

Re: Union & Nested queries

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