How to use PostgreSQL array in WHERE IN clause?

Question

I am trying to simplify the following SQL statement (wrapped into function for clarity).

What is a simpler/natural syntactical way to use array inside where ... in (/*array*/) clause? (without select * from unnest(...) boilerplate)

CREATE OR REPLACE FUNCTION get_items(p_ids int[])
 RETURNS SETOF text
 LANGUAGE sql
AS $$
  select t.name 
    from my_table t 
   where f.id in (select * from unnest(p_ids))
$$;

user330315 · Accepted Answer · 2021-07-17 07:54:01Z

10

Don't use IN use ANY, this also removes the need to unnest

where f.id = any (p_ids)

answered Jul 17, 2021 at 7:54

user330315

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

Collectives™ on Stack Overflow

How to use PostgreSQL array in WHERE IN clause?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related