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 vote223 views1 answer
List all permissions on a table in postgres
SQL
34 votes257 views6 answers
Alter table add foreign key mysql
SQL
19 votes218 views5 answers
Change column name mysql command line
SQL
1 vote234 views1 answer
Postgresql substring last
SQL
0 vote218 views3 answers
Postgresql allow remote connections
SQL
0 vote182 views1 answer
Mysql timeout 30 seconds
SQL
0 vote219 views1 answer
Add computed column to table sql server
SQL
3 votes225 views1 answer
Postgres add not null to existing column
SQL
7 votes219 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote219 views1 answer
Turn on foreign keys check mysql
SQL