Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CC07647610B for ; Thu, 3 Oct 2002 23:01:22 -0400 (EDT) Received: from wolff.to (wolff.to [66.93.197.35]) by postgresql.org (Postfix) with SMTP id 37E3F4760CE for ; Thu, 3 Oct 2002 23:01:22 -0400 (EDT) Received: (qmail 3967 invoked by uid 500); 4 Oct 2002 03:09:54 -0000 Date: Thu, 3 Oct 2002 22:09:54 -0500 From: Bruno Wolff III To: Vincent-Olivier Arsenault Cc: pgsql-sql@postgresql.org Subject: Re: order by x DESC, y ASC indexing problem Message-ID: <20021004030954.GA3484@wolff.to> Mail-Followup-To: Vincent-Olivier Arsenault , pgsql-sql@postgresql.org References: <3D9CF7EC.8080102@up4c.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3D9CF7EC.8080102@up4c.com> User-Agent: Mutt/1.3.25i X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/47 X-Sequence-Number: 9765 On Thu, Oct 03, 2002 at 22:07:40 -0400, Vincent-Olivier Arsenault wrote: > Hello, > > I saw a posting regarding this issue in august, with no solution... Then you didn't read the entire thread. You can create a new operator class to get the desired behavior.