Meta - Foreign Tables with PostgreSQL JSON(B) Columns about crate HOT 6 OPEN

Observations

PostgreSQL supports subscript JSON access only for JSONB:

-- Postgres 16
SELECT js['x'] FROM t_json;
--ERROR: cannot subscript type json because it does not support subscripting (SQLSTATE 42804)
SELECT js['x'] FROM t_jsonb;
-- works

from crate.

This did not work for me on the latest master, what version did you use @proddata ?

SELECT js['x'] FROM t_jsonb;
-- works

from crate.

On top of the issue described, rewriting where js['x'] > 1 to where cast(js ->> 'x' as int) > 1 is another issue.

from crate.

This did not work for me on the latest master, what version did you use @proddata ?

In PostgreSQL 16 ;)

from crate.

I think there is a workaround, could you try subscript_obj(js, 'x')?

from crate.

I think there is a workaround, could you try subscript_obj(js, 'x')?

also leads to "js['x']"
same as "js"['x']

from crate.