Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 5862A476A2D
	for <pgsql-sql@postgresql.org>; Fri, 13 Dec 2002 09:53:47 -0500 (EST)
Received: from mail.krake.de (mail.krake.de [217.7.96.73])
	by postgresql.org (Postfix) with ESMTP id 4022E476FC2
	for <pgsql-sql@postgresql.org>; Fri, 13 Dec 2002 09:52:29 -0500 (EST)
Received: from squid.krake.local (squid.krake.local [192.168.88.12])
	by mail.krake.de (8.11.6/8.11.6) with ESMTP id gBDEqUf24542;
	Fri, 13 Dec 2002 15:52:30 +0100
Content-Type: text/plain;
  charset="iso-8859-1"
From: Harald Krake <harald@krake.de>
Organization: Krake Softwaretechnik
To: Jakub Ouhrabka <jouh8664@ss1000.ms.mff.cuni.cz>
Subject: Re: order by and limit with multi-column index, bug?
Date: Fri, 13 Dec 2002 15:52:30 +0100
User-Agent: KMail/1.4.3
Cc: pgsql-sql@postgresql.org
References: <Pine.LNX.4.44.0212131544290.16417-100000@server>
In-Reply-To: <Pine.LNX.4.44.0212131544290.16417-100000@server>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <200212131552.30416.harald@krake.de>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/176
X-Sequence-Number: 10764

On Friday 13 December 2002 03:47 pm, Jakub Ouhrabka wrote:
> hi,
>
> could it be that "order by col1, col2 desc" is different from "order by
> col1 desc, col2 desc" ? these are different and it's correct.
>
> i'm not sure if this is your problem since i haven't digged into it...
> sorry... but check it to be sure...
>
> hth,
>
> kuba

bingo!
good morning.... 

thanx a lot!