Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by hub.org (8.10.1/8.10.1) with ESMTP id e96GVnJ77924 for ; Fri, 6 Oct 2000 12:31:49 -0400 (EDT) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.3) with HTTP id 1097222 for ; Fri, 06 Oct 2000 09:31:44 -0700 From: "Josh Berkus" Subject: Re: Re: [HACKERS] Counting bool flags in a complex query To: pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.3 Date: Fri, 06 Oct 2000 09:31:44 -0700 Message-ID: In-Reply-To: <24511.970808507@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200010/76 Tom, > Just FYI, I have committed code for 7.1 that allows ORDER > BY to work > correctly for a UNION'd query. A limitation is that you > can only do > ordering on columns that are outputs of the UNION: As far as I know, that limitation is standard to all SQL that supports UNION; the relational calculus (I'm told) is impossible otherwise. So ... we keep hearing about all the fantastic fixes in 7.1. When will a stable build show up? :-) -Josh