Message-ID: <4EAA3550.7080609@greenpeace.org>
Date: Fri, 28 Oct 2011 17:53:36 +1300
From: Jan Bakuwel <jan.bakuwel@greenpeace.org>
Organization: Greenpeace (http://www.greenpeace.org)
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.2.23) Gecko/20110921 Lightning/1.0b2 Thunderbird/3.1.15
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Different order by behaviour depending on where clause?
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hi,

I have a compound query with some grouping, having and order by's saved
as a view, say with name "myview".

A) select * from "myview" returns the results as expected in the correct
order (the order by is on fields "Category", "Year", "Month" and a few
other fields). The results are correctly ordered by these fields as
specified in the view.

B) select * from "myview" where "Year"=2011 and "Month"=1 also returns
the results as expected in the correct order (a subset of A).

however

C) select * from "myview" where "Year"=2011 and "Month" >= 1 and "Month"
<= 1 returns the same resultset as B but the order of the rows is not
correct (not even close; haven't been able to see any pattern).

Any idea how I can further analyse/diagnose this?

regards,
Jan