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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: JSON_VALUE() behavior when RETURNING bytea (expected base64 decoding)
Дата
Msg-id CAKFQuwYCrv-PvmWYVQibXX2QKq+0ggDwxuGm8vbmoY=ertQiZA@mail.gmail.com
обсуждение исходный текст
Ответ на JSON_VALUE() behavior when RETURNING bytea (expected base64 decoding)  (Shay Rojansky <roji@roji.org>)
Ответы Re: JSON_VALUE() behavior when RETURNING bytea (expected base64 decoding)
Список 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.

В списке pgsql-hackers по дате отправления: