A
A
Alexey2020-11-11 12:28:22
PostgreSQL
Alexey, 2020-11-11 12:28:22

How do you set the && array intersection filter in SQLAlchemy?

There is an array my_arr=[1,2,3] and there is a field in Table which is an array of integers. We need to find the lines in which the field array contains something from my_arr.
With the any filter, only one number will work:
.filter(Table.field.any(some_number)))

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question