Convert array to list in Postgres for select query

Question

In PostgreSQL I am trying to convert an array to a list say I have an array: v_arr

I want to use this array in the below query in Postgres:

Select * 
from table_name 
where column_name in (v_arr)

Please edit your question (by clicking on the edit link below it) and add the complete source code of your function. edit your question do not post code in comments. — user330315
– user330315, Commented Oct 11, 2018 at 17:08

Alberto_Contreras · Accepted Answer · 2018-10-11 17:07:40Z

5

You could use unnest

SELECT * 
FROM table_name 
WHERE column_name IN (SELECT unnest(v_arr));

user330315

answered Oct 11, 2018 at 16:50

Alberto_Contreras

592 bronze badges

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

1 Comment

the above returned nothing. Its returning null Alberto

Lukasz Szozda · Accepted Answer · 2018-10-11 16:45:12Z

3

You could use = ANY:

Select * from table_name where column_name = any (v_arr);

answered Oct 11, 2018 at 16:45

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

the above returned nothing. Its returning null

@StackAcc Please post your actual data.