On 08/15/2013 11:46 AM, Etienne Dube wrote:
> Hello,
>
> I don't really understand what is going on there, the result appears
> incorrect to me. The following page seems to offer some explanations as
> to what is happening:
> http://sql-info.de/postgresql/postgres-gotchas.html#1_6 . Indeed, adding
> OFFSET 0 to the "s" subquery solves the issue.
>
> Can somebody shed some light on this topic? Is this behaviour correct or
> should it be considered a bug?
See here for explanation:
http://www.postgresql.org/message-id/8569.1128439517@sss.pgh.pa.us
>
> Thanks!
> Etienne
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com