Home > mailing lists

Re: JSON_VALUE() behavior when RETURNING bytea (expected base64 decoding) - Mailing list pgsql-hackers

From	David G. Johnston
Subject	Re: JSON_VALUE() behavior when RETURNING bytea (expected base64 decoding)
Date	March 6 03:44:49
Msg-id	CAKFQuwYCrv-PvmWYVQibXX2QKq+0ggDwxuGm8vbmoY=ertQiZA@mail.gmail.com Whole thread Raw
In response to	JSON_VALUE() behavior when RETURNING bytea (expected base64 decoding) (Shay Rojansky <roji@roji.org>)
Responses	Re: JSON_VALUE() behavior when RETURNING bytea (expected base64 decoding)
List	pgsql-hackers

On Wednesday, March 5, 2025, Shay Rojansky <roji@roji.org> wrote:

SELECT JSON_VALUE(jsonb '"AQID"', '$' RETURNING bytea); -- Expected 0x010203, got AQID

I get \x41514944 which is precisely what I would expect since it what this query results in as well:

select 'AQID'::bytea;

David J.

From: Jacob Champion
Date: 06 March, 03:19:04
Subject: Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible

From: Sami Imseih
Date: 06 March, 03:46:45
Subject: Re: track generic and custom plans in pg_stat_statements