Re: SELECT DISTINCT ON removes results
От
David G. Johnston
Тема
Re: SELECT DISTINCT ON removes results
Дата
Msg-id
CAKFQuwY8jkPy1EB97WqLFMu2ATLQ7_ueHAczt5s4UDdp8-iMog@mail.gmail.com
Ответ на
Re: SELECT DISTINCT ON removes results (Guyren Howe)
Список
Дерево обсуждения
SELECT DISTINCT ON removes results Guyren Howe <guyren@gmail.com>
Re: SELECT DISTINCT ON removes results Geoff Winkless <pgsqladmin@geoff.dj>
Re: SELECT DISTINCT ON removes results "David G. Johnston" <david.g.johnston@gmail.com>
Re: SELECT DISTINCT ON removes results Guyren Howe <guyren@gmail.com>
Re: SELECT DISTINCT ON removes results Guyren Howe <guyren@gmail.com>
Re: SELECT DISTINCT ON removes results Guyren Howe <guyren@gmail.com>
Re: SELECT DISTINCT ON removes results "David G. Johnston" <david.g.johnston@gmail.com>
On Fri, Oct 28, 2016 at 2:17 PM, Guyren Howe <guyren@gmail.com> wrote:
On Oct 28, 2016, at 14:15 , Guyren Howe <guyren@gmail.com> wrote:On Oct 28, 2016, at 13:50 , David G. Johnston <david.g.johnston@gmail.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.
В списке pgsql-general по дате отправления
