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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


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@xxxxxxxxxxxxxx> 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.

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux