Re: SELECT DISTINCT ON removes results

On Fri, Oct 28, 2016 at 2:17 PM, Guyren Howe <guyren(at)gmail(dot)com> wrote:

> On Oct 28, 2016, at 14:15 , Guyren Howe <guyren(at)gmail(dot)com> wrote:
>
>
> On Oct 28, 2016, at 13:50 , David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
> wrote:
>
>
> ​On its face the statement "DISTINCT ON removes results" is not at all
> surprising given its definition.
>
>
> What is surprising is that it removes *all* results…
>
>
> The inner query on its own appears to produce the same results, but the
> left join with it in either case produces different results.
>

​Then maybe you can help us and create reproducible example that
demonstrates the bug so that it can be fixed.

David J.
​