Re: JSON_VALUE() behavior when RETURNING bytea (expected base64 decoding)

[David G. Johnston]

On Wednesday, March 5, 2025, Shay Rojansky <r...@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.