]> granicus.if.org Git - postgresql/commit
Support a COLLATE clause in plpgsql variable declarations.
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 17 Apr 2011 18:54:19 +0000 (14:54 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 17 Apr 2011 18:54:19 +0000 (14:54 -0400)
commitc94732585647437291ec3f4a9902eeffc65a6945
treecadfa7eae77b25b667e44160a3361f3c398c0c3e
parent88dc6fa7a164c306d8a1295769edb818d8520a3f
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.
doc/src/sgml/plpgsql.sgml
src/pl/plpgsql/src/gram.y
src/pl/plpgsql/src/pl_scanner.c
src/test/regress/expected/collate.linux.utf8.out
src/test/regress/sql/collate.linux.utf8.sql