Horton

Re: SQL/JSON in PostgreSQL

Pavel Stehule <pavel.stehule@gmail.com>

View thread View on postgr.es
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Oleg Bartunov <obartunov@gmail.com>
Cc: Pgsql Hackers <pgsql-hackers@postgresql.org>, Nikita Glukhov <n.gluhov@postgrespro.ru>, Teodor Sigaev <teodor@postgrespro.ru>, Alexander Korotkov <a.korotkov@postgrespro.ru>, andrew Dunstan <andrew@dunslane.net>
Date: 2017-03-01T17:34:05Z
Lists: pgsql-hackers 
>
>
>
>    1.
>
>    Added explicit casts bytea=>jsonb and jsonb=>bytea (for jsonb=>bytea
>    output using RETURNING bytea FORMAT JSONB and corresponding bytea=>jsonb
>    input using <jsonb_bytea_expr> FORMAT JSONB).
>
>
This point has sense in Oracle, where JSON is blob. But it is little bit
obscure in PostgreSQL context.

Regards

Pavel




> Best regards,
>
> Oleg
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
>

Commits

  1. SQL/JSON: support the IS JSON predicate

  2. SQL/JSON: add standard JSON constructor functions