On Wed, Dec 04, 2019 at 03:29:55AM -0800, James Salsman wrote:
> Thank you for your thoughtful reply. This might be much easier:
>
> How about adding another example to
> https://www.postgresql.org/docs/11/planner-stats.html ?
Not sure I see the parallel here. This page talks about planner
stati
"David G. Johnston" writes:
> On Thu, Dec 5, 2019 at 3:18 PM John Lumby wrote:
>> whereas
>> select count(DISTINCT ( parent_id , name) ) from mytable
>> is accepted.
> Correct, converting the two individual columns into a "tuple" allows the
> default tuple distinct-making infrastructure to be us
On Thu, Dec 5, 2019 at 3:18 PM John Lumby wrote:
> In PostgreSQL 12.1 Documentation chapter 4.2.7. Aggregate Expressions it
> says
>
>
> The syntax of an aggregate expression is one of the following:
> ...
> aggregate_name (DISTINCT expression [ , ... ] [ order_by_clause ] ) [
> FILTER ( WHERE
In PostgreSQL 12.1 Documentation chapter 4.2.7. Aggregate Expressions it says
The syntax of an aggregate expression is one of the following:
...
aggregate_name (DISTINCT expression [ , ... ] [ order_by_clause ] ) [ FILTER (
WHERE filter_clause ) ]
...
I believe this is incorrect in the case