On Fri, Oct 28, 2016 at 2:17 PM, Guyren Howe <guyren@xxxxxxxxx> wrote:
On Oct 28, 2016, at 14:15 , Guyren Howe <guyren@xxxxxxxxx> wrote:On Oct 28, 2016, at 13:50 , David G. Johnston <david.g.johnston@xxxxxxxxx> 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.
