Re: Json:- Accepting 'integer' value

2021-07-13 Thread Tom Lane
shaurya jain <12345shau...@gmail.com> writes: > But while we checking the same thing in Oracle it doesn't accept this. Is > it an issue with Postgres data type? I'd call it an issue with Oracle. We follow RFC 7159, which specifies that "bare" scalars (numbers, strings, booleans) are valid JSON va

Json:- Accepting 'integer' value

2021-07-13 Thread shaurya jain
Hi Team, Postgres Version:- 12.7 Issue:- JSON data type column accepting 'integer' value Priority:-Minor Below is the table definition and insert statement, which is working in Postgres however it doesn't work in oracle with check constraint(jj is JSON strict). postgres=# \d kp