Select plain array against array

Question

I have a table looking like:

Table_A

| name | email_addresses                                 |
| a    | ['[email protected]']                               |
| b    | ['[email protected]', '[email protected]']             |
| c    | ['[email protected]', '[email protected]']         |
| d    | ['[email protected]', '[email protected]', '[email protected]'] |

The field type of email_addresses is JSONB

In simple SQL, my query is like:

select * from Table_A where email_addresses = ['[email protected]', '[email protected]']

Which result should be : a, c, d

But not sure how to build this query in postgress json

emomaliev · Accepted Answer · 2022-10-11 06:30:02Z

1

You can use the ?| operator to compare the value of your array with the json field

select * from my_table where email_addresses::jsonb ?| array['[email protected]', '[email protected]'];

DBfiddle Deme

answered Oct 11, 2022 at 6:30

emomaliev

2,4233 gold badges12 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Select plain array against array

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