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 Transactions(
feeAmount JSONB
);
INSERT INTO Transactions VALUES ('{"value": null, "currency": "AUD"}');
INSERT INTO Transactions VALUES ('{"value": "5", "currency": "AUD"}');
INSERT INTO Transactions VALUES (NULL);
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
SELECT *
FROM Transactions
WHERE coalesce(feeAmount->'value','null') <> 'null'
| feeamount |
|---|
| {"value": "5", "currency": "AUD"} |
SELECT 1