postgresql expression wher id is in array

Question

I have an array of ids such as:

a = [13, 51, 99, 143, 225, 235, 873]

What is the most efficient way of getting the records where the id is in the array.

I don't really want to use or such as WHERE id = 13 || 92 , as the array could be extremely long. I've tried this:

select * from authors where id <@ [11, 8, 51, 62, 7];

but that's not correct.

Thanks

user330315 · Accepted Answer · 2017-01-23 18:35:37Z

1

Use any

select * 
from authors 
where id = any (array[11, 8, 51, 62, 7]);

answered Jan 23, 2017 at 18:35

user330315

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

1 Answer 1