From 0e5b14410e2bb54d191bbb7bb21a674ccabe768e Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?=C3=81lvaro=20Herrera?= Date: Tue, 7 Jan 2025 20:07:32 +0100 Subject: Fix error message wording The originals are ambiguous and a bit out of style. Reviewed-by: Amit Langote Discussion: https://postgr.es/m/202412141243.efesjyyvzxsz@alvherre.pgsql --- src/backend/parser/parse_expr.c | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'src/backend/parser/parse_expr.c') diff --git a/src/backend/parser/parse_expr.c b/src/backend/parser/parse_expr.c index 84d214f5c74..d1f64f8f0a5 100644 --- a/src/backend/parser/parse_expr.c +++ b/src/backend/parser/parse_expr.c @@ -4113,8 +4113,9 @@ transformJsonReturning(ParseState *pstate, JsonOutput *output, const char *fname if (returning->typid != JSONOID && returning->typid != JSONBOID) ereport(ERROR, (errcode(ERRCODE_DATATYPE_MISMATCH), - errmsg("cannot use RETURNING type %s in %s", + errmsg("cannot use type %s in RETURNING clause of %s", format_type_be(returning->typid), fname), + errhint("Try returning json or jsonb."), parser_errposition(pstate, output->typeName->location))); } else @@ -4233,7 +4234,7 @@ transformJsonSerializeExpr(ParseState *pstate, JsonSerializeExpr *expr) if (typcategory != TYPCATEGORY_STRING) ereport(ERROR, (errcode(ERRCODE_DATATYPE_MISMATCH), - errmsg("cannot use RETURNING type %s in %s", + errmsg("cannot use type %s in RETURNING clause of %s", format_type_be(returning->typid), "JSON_SERIALIZE()"), errhint("Try returning a string type or bytea."))); -- cgit v1.2.3