Support a COLLATE clause in plpgsql variable declarations.
Tom Lane <tgl@sss.pgh.pa.us>
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.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/plpgsql.sgml | modified | +26 −6 |
| src/pl/plpgsql/src/gram.y | modified | +41 −6 |
| src/pl/plpgsql/src/pl_scanner.c | modified | +1 −0 |
| src/test/regress/expected/collate.linux.utf8.out | modified | +40 −0 |
| src/test/regress/sql/collate.linux.utf8.sql | modified | +28 −0 |