Calling json_* functions with JSONB data
От | Peter van Hardenberg |
---|---|
Тема | Calling json_* functions with JSONB data |
Дата | |
Msg-id | CABTbUpgQ3b-JTNUaLPLGL3aw4V9LtwFnbLuHhA9-BTVyGcggNQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Calling json_* functions with JSONB data
Re: Calling json_* functions with JSONB data Re: Calling json_* functions with JSONB data Re: Calling json_* functions with JSONB data |
Список | pgsql-hackers |
Hi there,
I noticed it was very easy to accidentally call the json_* form of JSON manipulation functions with jsonb data as input. This is pretty sub-optimal, since it involves rendering the jsonb then reparsing it and calling the json_* form of the function.
Fortunately, this seems quite easy to resolve by taking advantage of our ability to add json_*(jsonb) form of the functions.
--
I talked this over with Andrew who had no objections and suggested I float it on the list before writing a patch. Looks pretty straightforward, just a few new data rows in pg_proc.h.
Anyone have any concerns or suggestions?
-p
Peter van Hardenberg
San Francisco, California
"Everything was beautiful, and nothing hurt."—Kurt Vonnegut
San Francisco, California
"Everything was beautiful, and nothing hurt."—Kurt Vonnegut
В списке pgsql-hackers по дате отправления: