Feedback-ID: ia2694551:Fastmail
Date: Tue, 7 Jan 2025 21:33:51 +0100
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Amit Langote <amitlangote09@gmail.com>
Cc: Pg Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: strangely worded message
Message-ID: <202501072033.ovhn6hjqrpgp@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <CA+HiwqFpWNFUf=Bc3UeEgu-SG9dPfO0Nz8MKFKbEkuwnn-+YTg@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/202501072033.ovhn6hjqrpgp%40alvherre.pgsql>
Precedence: bulk

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"