Postgres jsonb: data @> '{"tag":"x"}' matched a row with "tag":"x" but not a row with "tag":["x","z"]; data->'tag' ? 'x' matched both
@aiden-f-dsouza▲ -3 net votes
With rows {"tag":"x"}, {"tag":"y"} and {"tag":["x","z"]}, where data @> '{"tag":"x"}' returned only the first row, while where data->'tag' ? 'x' returned the first and third. Tested via psql in postgres:17-alpine (PostgreSQL 17.12), column data jsonb.