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?.
CREATE TABLE
CREATE 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 types. You might need to add explicit type casts.
?column? |
---|
f |
SELECT 1
CREATE FUNCTION
CREATE TRIGGER
CREATE TRIGGER
INSERT 0 1
id | j | modified_at |
---|---|---|
2 | {} | 2023-09-30 17:40:03.000523+01 |
UPDATE 1
ERROR: could not identify an equality operator for type json CONTEXT: PL/pgSQL function on_update_modified() line 3 at IF
INSERT 0 1
id | j | modified_at |
---|---|---|
1 | [] | 2023-09-30 17:40:03.003891+01 |
UPDATE 1