Re: string_agg delimiter having no effect with order by - Mailing list pgsql-bugs

Pavel Stehule <pavel.stehule@gmail.com> writes:
> but still when we remove one parametric string_agg, then this issue
> will not be documented.

How so?  This paragraph will still be there:

   <para>
    When dealing with multiple-argument aggregate functions, note that the
    <literal>ORDER BY</> clause goes after all the aggregate arguments.
    For example, this:
<programlisting>
SELECT string_agg(a, ',' ORDER BY a) FROM table;
</programlisting>
    not this:
<programlisting>
SELECT string_agg(a ORDER BY a, ',') FROM table;  -- incorrect
</programlisting>
    The latter is syntactically valid, but it represents a call of a
    single-argument aggregate function with two <literal>ORDER BY</> keys
    (the second one being rather useless since it's a constant).
   </para>


            regards, tom lane