Check that JSONB array does not contain string?

Question

I would like to select rows where a JSONB column does not contain a value. I see how to check for existence (WHERE vegetables::jsonb ? 'carrots'), but not the opposite. Can anyone help?

Thank you

GMB · Accepted Answer · 2020-12-02 19:07:59Z

5

Just negate that condition:

WHERE NOT (vegetables::jsonb ? 'carrots')

answered Dec 2, 2020 at 19:07

GMB

224k25 gold badges103 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Check that JSONB array does not contain string?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related