Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 70A084766A3 for ; Wed, 22 May 2002 10:06:44 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 13336476139 for ; Wed, 22 May 2002 09:57:07 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g4MDunW23763; Wed, 22 May 2002 09:56:49 -0400 (EDT) To: Christoph Haller Cc: pgsql-sql@postgresql.org Subject: Re: Bug with ORDER BY expression [ ASC | DESC ] ? In-reply-to: <200205221317.PAA26760@rodos> References: <200205221317.PAA26760@rodos> Comments: In-reply-to Christoph Haller message dated "Wed, 22 May 2002 15:17:01 +0700" Date: Wed, 22 May 2002 09:56:49 -0400 Message-ID: <23760.1022075809@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200205/241 X-Sequence-Number: 7876 Christoph Haller writes: > select distinct on (o.sid,o.timepoint,o.lid,o.mid) o.sid,o.timepoint,o.lid,o.mid,o.value > from onfvalue o, tempreftime t > where o.sid=t.sid and o.timepoint=t.timepoint and o.lid=t.lid and o.mid=t.mid > order by o.sid,o.timepoint,o.lid,o.mid,o.entrancetime desc; > but the result is coming in ascending order. Perhaps you meant to say order by o.sid desc, o.timepoint desc, o.lid desc, o.mid desc, o.entrancetime desc; regards, tom lane