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@xxxxxxxxxxxxx
Thanks! Etienne
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
