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

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

To: Nikhil Ingale <niks.bgm@xxxxxxxxx>, pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: Re: IS JSON STRICT - In oracle => postgres ??
From: Peter Eisentraut <peter@xxxxxxxxxxxxxx>
Date: Tue, 20 Jun 2023 10:07:05 +0200
Feedback-id: ie0a040ee:Fastmail
In-reply-to: <CALXkTpx66eJKJM1YPFmYJNJwn2LeGAb7qkiXkhyOGBCoKA4isQ@mail.gmail.com>
References: <CALXkTpx66eJKJM1YPFmYJNJwn2LeGAb7qkiXkhyOGBCoKA4isQ@mail.gmail.com>
User-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.11.2

On 14.06.23 12:00, Nikhil Ingale wrote:

In oracle we can use the *is json* check constraint for the json columnto 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.

Follow-Ups:
- Re: IS JSON STRICT - In oracle => postgres ??
  - From: Nikhil Ingale

References:
- IS JSON STRICT - In oracle => postgres ??
  - From: Nikhil Ingale

Prev by Date: Re: What does invalid_transaction_state 25000 mean
Next by Date: Re: IS JSON STRICT - In oracle => postgres ??
Previous by thread: Re: IS JSON STRICT - In oracle => postgres ??
Next by thread: Re: IS JSON STRICT - In oracle => postgres ??
Index(es):
- Date
- Thread

[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