By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
ERROR: operator does not exist: json = json
LINE 2: SELECT (1, '{}', now())::tbl_js IS DISTINCT FROM (1, '{}', n...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
?column? |
---|
f |
1 rows affected
id | j | modified_at |
---|---|---|
2 | {} | 2022-04-12 23:53:47.228915+01 |
ERROR: could not identify an equality operator for type json
CONTEXT: PL/pgSQL function on_update_modified() line 3 at IF
1 rows affected
id | j | modified_at |
---|---|---|
1 | [] | 2022-04-12 23:53:47.233499+01 |