Re: strangely worded message

Alvaro Herrera <alvherre@alvh.no-ip.org>

From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Amit Langote <amitlangote09@gmail.com>
Cc: Pg Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-01-07T20:33:51Z
Lists: pgsql-hackers
Hi Amit,

On 2024-Dec-16, Amit Langote wrote:

> > ERROR:  cannot use type %s in RETURNING clause of %s
> > DETAIL:  Only types json and jsonb are allowed in the RETURNING clause.

> I think I'd go with the one you chose.

Actually I noticed that the one in JSON_SERIALIZE() already has a
different hint, "Try returning a string type or bytea.", so I made the
other ones mimic that (and made it a hint rather than detail).

> Are you planning to push a fix yourself or would you like me to?

I just pushed it to both master and 17.

Thanks for looking!

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"Si quieres ser creativo, aprende el arte de perder el tiempo"



Commits

  1. Fix error message wording

  2. Add more SQL/JSON constructor functions