Port Bug Report: Query processing seems broken

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : Joerg Fischer
Your email address      : fischer@zkm.de

Category                : runtime: back-end: SQL
Severity                : serious

Summary: Query processing seems broken

System Configuration
--------------------
  Operating System   : SuSE Linux 6.0 (i386) - Kernel 2.0.36 (ELF)

  PostgreSQL version : 6.5beta1

  Compiler used      : egcs-2.91.60

Hardware:
---------
Pentium II-450, 128 MB RAM, 9 GB U2W HD, Adaptec U2W Cont.

Linux salon09 2.0.36 #3 Mon Apr 26 20:44:52 CEST 1999 i686 unknown


Versions of other tools:
------------------------


--------------------------------------------------------------------------

Problem Description:
--------------------


--------------------------------------------------------------------------

Test Case:
----------
The following query fails with PGSQL 6.5beta1,
even though it seems correct:

select superext as name from OM_ExtendInheritance where subext in (
    select superext as name from OM_ExtendInheritance where subext in (
      select 'Patient' as name
    )
    union select 'Patient' as name
  );

Postgresql reports:
ERROR:  parser: parse error at or near "union"


Could there be a problem handling nested expressions?



--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------