Account for collation when coercing the output of a SQL function.
Tom Lane <tgl@sss.pgh.pa.us>
Account for collation when coercing the output of a SQL function. Commit 913bbd88d overlooked that the result of coerce_to_target_type might need collation fixups. Per report from Andreas Joseph Krogh. Discussion: https://postgr.es/m/VisenaEmail.72.37d08ec2b8cb8fb5.17179940cd3@tc7-visena
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/executor/functions.c | modified | +3 −0 |
| src/test/regress/expected/collate.out | modified | +14 −1 |
| src/test/regress/sql/collate.sql | modified | +8 −0 |
Discussion
- ERROR: could not determine which collation to use for string comparison 2 messages · 2020-04-14