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