Request a Demo
Home   >   mailing lists

Re: Strange result with "SELECT ... ORDER BY random() LIMIT 1" and JOINs - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Strange result with "SELECT ... ORDER BY random() LIMIT 1" and JOINs
Date
Msg-id [email protected]
Whole thread Raw
In response to Strange result with "SELECT ... ORDER BY random() LIMIT 1" and JOINs  (Etienne Dube <[email protected]>)
List pgsql-general
Tree view 
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/[email protected]

>
> Thanks!
> Etienne
>
>
>


--
Adrian Klaver
[email protected]

pgsql-general by date:

Previous
From: "Janek Sendrowski"
Date:
Subject: devide and summarize sql result (all)
Next
From: Vik Fearing
Date:
Subject: Re: Escape string for LIKE op