Hi

I found inconsistency in casting the value "null" of jsonb type to scalar
types.

(2026-07-05 14:54:08) postgres=# select 'null'::jsonb::int is null;
┌──────────┐
│ ?column? │
╞══════════╡
│ t        │
└──────────┘
(1 row)

(2026-07-05 14:56:26) postgres=# select 'null'::jsonb::varchar is null;
┌──────────┐
│ ?column? │
╞══════════╡
│ f        │
└──────────┘
(1 row)

Is it expected behaviour?

Regards

Pavel

Reply via email to