Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT DISTINCT ON removes results - Mailing list pgsql-general

From Guyren Howe
Subject Re: SELECT DISTINCT ON removes results
Date
Msg-id C944289D-1930-4820-99AF-3E2EB2460DCB@gmail.com
Whole thread Raw
In response to Re: SELECT DISTINCT ON removes results  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: SELECT DISTINCT ON removes results  (Guyren Howe <guyren@gmail.com>)
List pgsql-general
Tree view
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…


pgsql-general by date:

Previous
From: Steve Clark
Date:
Subject: Re: deadlock error - version 8.4 on CentOS 6
Next
From: Guyren Howe
Date:
Subject: Re: SELECT DISTINCT ON removes results