Postgres Pro
Downloads
Home   >   mailing lists

Re: IS JSON STRICT - In oracle => postgres ?? - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: IS JSON STRICT - In oracle => postgres ??
Date
Msg-id 5cd1da78-e1ad-42d2-9f33-9aa0b163293e@eisentraut.org
Whole thread Raw
In response to IS JSON STRICT - In oracle => postgres ??  (Nikhil Ingale <niks.bgm@gmail.com>)
Responses Re: IS JSON STRICT - In oracle => postgres ??
List pgsql-admin
Tree view 
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 by date:

Previous
From: Debraj Manna
Date:
Subject: Re: What does invalid_transaction_state 25000 mean
Next
From: Nikhil Ingale
Date:
Subject: Re: IS JSON STRICT - In oracle => postgres ??