Re: IS JSON STRICT - In oracle => postgres ??

Поиск
Список
Период
Сортировка
От Nikhil Ingale
Тема Re: IS JSON STRICT - In oracle => postgres ??
Дата
Msg-id CALXkTpyq1J+QpYJ7xuoS8+sVpAFy2De2QKak6h1ELYvcqgc7Sw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: IS JSON STRICT - In oracle => postgres ??  (Peter Eisentraut <peter@eisentraut.org>)
Список pgsql-admin
Дерево обсуждения
Information from you guys helped to resolve the issue.
Thank you all for the valuable inputs.

On Tue, Jun 20, 2023 at 1:37 PM Peter Eisentraut <peter@eisentraut.org> wrote:
On 14.06.23 12:00, Nikhil Ingale wrote:
> In oracle we can use the *is json* check constraint for the json column
> to ensure the data is well formed.
>
> How do we ensure the same in postgres database?

PostgreSQL 16 has an IS JSON predicate.

It doesn't have a STRICT clause, which I don't see in the SQL standard.
So it might not do exactly the same thing.

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: IS JSON STRICT - In oracle => postgres ??
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: What does invalid_transaction_state 25000 mean