Fix handling of collation in SQL-language functions.

[postgresql] / src / backend / parser / parse_param.c

diff --git a/src/backend/parser/parse_param.c b/src/backend/parser/parse_param.c
index 1cf255669acbaba269371cb5746d89ba6ff53b6b..1895f92d7c4187fd7d154ee54f5c608db687e7c6 100644 (file)
--- a/src/backend/parser/parse_param.c
+++ b/src/backend/parser/parse_param.c
@@ -231,6 +231,11 @@ variable_coerce_param_hook(ParseState *pstate, Param *param,
                 */
                param->paramtypmod = -1;
 
+               /*
+                * This module always sets a Param's collation to be the default for
+                * its datatype.  If that's not what you want, you should be using
+                * the more general parser substitution hooks.
+                */
                param->paramcollid = get_typcollation(param->paramtype);
 
                /* Use the leftmost of the param's and coercion's locations */