pgsql: Support a COLLATE clause in plpgsql variable declarations. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Support a COLLATE clause in plpgsql variable declarations.
Date
Msg-id E1QBX76-0003mc-Kk@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: foreach() and list_delete() don't mix.
Next
From: Tom Lane
Date:
Subject: pgsql: Add check for matching column collations in ALTER TABLE ... INHE