OSDN Git Service

Remove the single-argument form of string_agg(). It added nothing much in
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 5 Aug 2010 18:21:31 +0000 (18:21 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 5 Aug 2010 18:21:31 +0000 (18:21 +0000)
commitbdd538c571ff6712b9c17b179791592629ad5207
tree8b562b4a04aeddc3ea425d8f7705aa31088de139
parent6a366113e6f9661fa270197807dadde55e69b5ed
Remove the single-argument form of string_agg().  It added nothing much in
functionality, while creating an ambiguity in usage with ORDER BY that at
least two people have already gotten seriously confused by.  Also, add an
opr_sanity test to check that we don't in future violate the newly minted
policy of not having built-in aggregates with the same name and different
numbers of parameters.  Per discussion of a complaint from Thom Brown.
doc/src/sgml/func.sgml
doc/src/sgml/syntax.sgml
src/backend/utils/adt/varlena.c
src/include/catalog/catversion.h
src/include/catalog/pg_aggregate.h
src/include/catalog/pg_proc.h
src/include/utils/builtins.h
src/test/regress/expected/aggregates.out
src/test/regress/expected/opr_sanity.out
src/test/regress/sql/aggregates.sql
src/test/regress/sql/opr_sanity.sql