PostgreSQL get parameter bigint array

Question

I have a table which has a column id with bigint type . I need to create function which will take a parameter bigint[] and in function I should check where id in (array)

CREATE OR REPLACE FUNCTION my_function(ids bigint[])
 select * from table where id in ($1)

Function creates successfully , but when I call it

SELECT * FROM my_function(ARRAY [1,2,3,4]);

I get an error:

 ERROR:  operator does not exist: bigint = bigint[]

You want the = ANY operator, not in.

Pointy
– Pointy

2017-06-05 14:41:41 +00:00
Commented Jun 5, 2017 at 14:41 — Pointy
– Pointy, Commented Jun 5, 2017 at 14:41

Clodoaldo Neto · Accepted Answer · 2017-06-05 15:05:30Z

1

As commented:

where id = any ($1)

https://www.postgresql.org/docs/current/static/functions-comparisons.html#AEN21104

answered Jun 5, 2017 at 15:05

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL get parameter bigint array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related