Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #8629: Strange resultset when using CTE or a subselect - Mailing list pgsql-bugs

From bricklen
Subject Re: BUG #8629: Strange resultset when using CTE or a subselect
Date
Msg-id CAGrpgQ-1BK9q=HYXSMBb1dBHcOL9VRJ08bqoAnsy_3EAoiGaLg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #8629: Strange resultset when using CTE or a subselect  (Jonathan Camile <jonathan.camile@gmail.com>)
List pgsql-bugs
Tree view 
>
>> 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.

pgsql-bugs by date:

Previous
From: David Johnston
Date:
Subject: Re: BUG #8629: Strange resultset when using CTE or a subselect
Next
From: Vik Fearing
Date:
Subject: Re: BUG #8630: Planner behavior change between PG 9.0.14 and 9.3.1