Re: string_agg

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "j(dot)v(dot)keller(at)t-online(dot)de" <j(dot)v(dot)keller(at)t-online(dot)de>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: string_agg
Date: 2023-12-28 22:52:00
Message-ID: CAKFQuwbGRVkSVnVmvMR6Gq+SnUSHyH7VVa2BO+vJDTjqSc5umA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Wednesday, December 27, 2023, PG Doc comments form <
noreply(at)postgresql(dot)org> wrote:

> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/16/functions-aggregate.html
> Description:
>
> Please add the argument "distinct" to the documentation of the
> aggregate-function "string_agg". It's used to omit any duplicates in the
> result string.
>

string_agg isn’t special in this regard so instead of cluttering up every
function with distinct we instead choose to document it as a syntax feature
of aggregate functions in general.

https://www.postgresql.org/docs/16/sql-expressions.html#SYNTAX-AGGREGATES

David J.

In response to

  • string_agg at 2023-12-27 22:38:53 from PG Doc comments form

Browse pgsql-docs by date

  From Date Subject
Next Message Dull Bananas 2023-12-30 00:25:30 Transition relation clarification
Previous Message PG Doc comments form 2023-12-27 22:38:53 string_agg