How to filter an array using an array with postgresql

Question

I have a Postgres DB and I have table A with a field category which is a string Array. How do i find all records on Table A whose category array field contains the all the strings in this array? --> ['test1', 'test2'].

Searching on google give me only when category is a String. But in my case it is an array.

GMB · Accepted Answer · 2020-10-09 21:35:49Z

3

You can use array containment operator @>:

select * from a where category @> array['test1', 'test2']

This ensures that category contains all elements of the right operand.

answered Oct 9, 2020 at 21:35

GMB

224k25 gold badges103 silver badges151 bronze badges

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

Collectives™ on Stack Overflow

How to filter an array using an array with postgresql

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