Received: from mailer.zkm.de (mailer.zkm.de [193.197.168.18]) by hub.org (8.9.3/8.9.3) with ESMTP id CAA22511 for ; Wed, 5 May 1999 02:52:29 -0400 (EDT) (envelope-from fischer@zkm.de) Received: from zkm.de (joerg@www4.zkm.de [193.197.168.203]) by mailer.zkm.de (8.8.8/8.8.8) with ESMTP id IAA01808 for ; Wed, 5 May 1999 08:50:33 +0200 (MET DST) Sender: joerg@zkm.de Message-ID: <372FEB66.68402589@zkm.de> Date: Wed, 05 May 1999 08:55:34 +0200 From: Joerg Fischer Organization: ZKM Karlsruhe X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: de, en MIME-Version: 1.0 To: PGSQL-SQL Subject: SQL-Query error with PGSQL 6.5beta1 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi! If there is a separate beta mailing list for these kind of incidents, I am sorry, but I could not find it. Now, here is the problem. 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? Thank you! Regards Joerg Fischer