Thread: pgsql: Support a COLLATE clause in plpgsql variable declarations.

Support a COLLATE clause in plpgsql variable declarations.

This allows the usual rules for assigning a collation to a local variable
to be overridden.  Per discussion, it seems appropriate to support this
rather than forcing all local variables to have the argument-derived
collation.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/c94732585647437291ec3f4a9902eeffc65a6945

Modified Files
--------------
doc/src/sgml/plpgsql.sgml                        |   32 ++++++++++++---
src/pl/plpgsql/src/gram.y                        |   47 +++++++++++++++++++---
src/pl/plpgsql/src/pl_scanner.c                  |    1 +
src/test/regress/expected/collate.linux.utf8.out |   40 ++++++++++++++++++
src/test/regress/sql/collate.linux.utf8.sql      |   28 +++++++++++++
5 files changed, 136 insertions(+), 12 deletions(-)