Fix up text concatenation so that it accepts all the reasonable cases that

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 2d4db3675fa7a2f4831b755bc98242421901042f

Author: Tom Lane <tgl@sss.pgh.pa.us>

Date: 2007-06-06T23:00:50Z

Fix up text concatenation so that it accepts all the reasonable cases that
were accepted by prior Postgres releases.  This takes care of the loose end
left by the preceding patch to downgrade implicit casts-to-text.  To avoid
breaking desirable behavior for array concatenation, introduce a new
polymorphic pseudo-type "anynonarray" --- the added concatenation operators
are actually text || anynonarray and anynonarray || text.

Files

Path	Change	+/−
doc/src/sgml/datatype.sgml	modified	+13 −3
doc/src/sgml/extend.sgml	modified	+15 −3
doc/src/sgml/func.sgml	modified	+37 −9
doc/src/sgml/plpgsql.sgml	modified	+4 −4
doc/src/sgml/xfunc.sgml	modified	+5 −3
src/backend/catalog/pg_proc.c	modified	+3 −1
src/backend/executor/functions.c	modified	+6 −4
src/backend/parser/parse_agg.c	modified	+2 −2
src/backend/parser/parse_coerce.c	modified	+79 −44
src/backend/parser/parse_func.c	modified	+4 −4
src/backend/utils/adt/pseudotypes.c	modified	+27 −1
src/backend/utils/adt/xml.c	modified	+2 −2
src/backend/utils/fmgr/funcapi.c	modified	+26 −13
src/include/catalog/catversion.h	modified	+2 −2
src/include/catalog/pg_operator.h	modified	+6 −2
src/include/catalog/pg_proc.h	modified	+15 −6
src/include/catalog/pg_type.h	modified	+4 −1
src/include/utils/builtins.h	modified	+3 −1
src/include/utils/lsyscache.h	modified	+2 −2
src/pl/plpgsql/src/pl_comp.c	modified	+3 −2
src/test/regress/expected/text.out	modified	+28 −0
src/test/regress/sql/text.sql	modified	+15 −0