Postgresql pass array in function

-- Definition
CREATE FUNCTION my_method(INT[]) RETURNS VOID AS $$ 
       ...
END $$ LANGUAGE plpgsql;

-- Use
SELECT my_method(ARRAY [1,2,3,4])

-- The reference (stackoverflow answer) defines two other methods to do this

Source: stackoverflow.com

Similar codes

0 vote133 views1 answer
Sql select duplicates based on two columns
SQL
0 vote135 views1 answer
Show size of all tables postgres
SQL
3 votes161 views5 answers
Duplicate table sql
SQL
0 vote142 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
2 votes129 views1 answer
Mysql sysdate
SQL
0 vote137 views1 answer
Sql contains vs like
SQL
4 votes131 views1 answer
Id primary key auto generated
SQL
0 vote128 views1 answer
Json not contains mysql
SQL
0 vote140 views1 answer
Not equal to blank in mysql
SQL
0 vote134 views1 answer
Postgresql comandos basicos
SQL