PostgreSQL select Data where Array is in array

Question

I have an database like this.

vendors
id    title        
1    'Papa Johns'
2    'Google'

I have an starred array that could look like this: [1] or [1, 2]

I want to write a query which selects everything in the starred array, this is what I tried:

SELECT * FROM vendors WHERE vendors.id IN [1, 2]

But that gave a syntax error, I'm not sure of the correct syntax?

klin · Accepted Answer · 2017-11-08 01:02:04Z

2

If you want to use integer constans, use IN:

SELECT * 
FROM vendors 
WHERE vendors.id IN (1, 2);

Alternatively, you can use ANY(array):

SELECT * 
FROM vendors 
WHERE vendors.id = ANY(array[1, 2]);

answered Nov 8, 2017 at 1:02

klin

123k15 gold badges240 silver badges262 bronze badges

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

1 Answer 1