Json:- Accepting 'integer' value
| От | shaurya jain |
|---|---|
| Тема | Json:- Accepting 'integer' value |
| Дата | |
| Msg-id | CAHHJ3NSF1cLZ2Wika_oQDq54a0hc7DvVh66N0PgjkGqB9UfmAA@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Json:- Accepting 'integer' value
|
| Список | pgsql-general |
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
Table "public.kp"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+--------------------------------
id | integer | | not null | nextval('kp_id_seq'::regclass)
jj | json | | |
--
Table "public.kp"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+--------------------------------
id | integer | | not null | nextval('kp_id_seq'::regclass)
jj | json | | |
postgres=# insert into kp(jj) values('98');
INSERT 0 1
INSERT 0 1
But while we checking the same thing in Oracle it doesn't accept this. Is it an issue with Postgres data type?
В списке pgsql-general по дате отправления: