UNION/INTERSECT in subselects - Mailing list pgsql-hackers

From Florent Guillaume
Subject UNION/INTERSECT in subselects
Date
Msg-id 20000901211901.A23119@twin.efge.org
Whole thread Raw
List pgsql-hackers
(sorry if you receive this twice)

Hi, I'm using 7.0.2 and I have a problem with UNION in some subselects,
namely the following works:       select * from a where a.f in (select 1)
but this doesn't:       select * from a where a.f in (select 1 union select 2)

In the grammar we have : in_expr:  SubSelect | ...
but SubSelect doesn't allow UNIONs, only select_clause does.

Could in_expr be changed to use select_clause instead without adverse
ill effects ?

In fact SubSelect is used all over the place, so maybe it's better to
switch select_clause and SubSelect in the definitions for SelectStmt,
select_clause and SubSelect ?


Thanks,
Florent

(Please Cc: me in your answers)



pgsql-hackers by date:

Previous
From: Peter Mount
Date:
Subject: The next release
Next
From: Jie Liang
Date:
Subject: Re: [SQL] 7.0.2: Arrays