Re: string_agg delimiter having no effect with order by

2010/8/5 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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
>

ok

Regards

Pavel Stehule