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

18 votes117 views3 answers
Mysql number format
SQL
0 vote134 views1 answer
Get a list of tables and the primary key
SQL
2 votes140 views1 answer
Mysql shell insert into
SQL
-1 vote128 views1 answer
Sql syntax create timestamp column
SQL
7 votes130 views2 answers
MySQL IF without else
SQL
1 vote126 views1 answer
Oracle difference between two dates in years
SQL
0 vote130 views1 answer
How to drop a trigger in postgresql
SQL
0 vote128 views1 answer
Declarative base sqlalchemy
SQL
15 votes134 views6 answers
Laravel db transaction
SQL
1 vote133 views1 answer
Mysql change root mysql_native_password
SQL