Re: BUG #8629: Strange resultset when using CTE or a subselect

From: bricklen <bricklen(at)gmail(dot)com>
To: Jonathan Camile <jonathan(dot)camile(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8629: Strange resultset when using CTE or a subselect
Date: 2013-11-25 21:42:06
Message-ID: CAGrpgQ-1BK9q=HYXSMBb1dBHcOL9VRJ08bqoAnsy_3EAoiGaLg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>
>> Try with OFFSET 5 LIMIT 5. The offset should be applied *before* the
>> LIMIT.
>>
>
David Johnston just proved my suggestion about the order of ORDER BY and
OFFSET was full of it; I should have tested before suggesting that.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Vik Fearing 2013-11-25 22:07:20 Re: BUG #8630: Planner behavior change between PG 9.0.14 and 9.3.1
Previous Message David Johnston 2013-11-25 19:38:57 Re: BUG #8629: Strange resultset when using CTE or a subselect