2010/8/5 Tom Lane <t...@sss.pgh.pa.us>: > Pavel Stehule <pavel.steh...@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 >
ok Regards Pavel Stehule -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
