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

1 vote377 views2 answers
Postgres cast as decimal
SQL
1 vote329 views1 answer
Sql week commencing date
SQL
0 vote404 views1 answer
Sql query to select even numbers
SQL
0 vote366 views1 answer
Sql last 3 rows
SQL
8 votes353 views1 answer
How to remove tables from postgresql
SQL
0 vote337 views1 answer
Sql server order by nulls last
SQL
0 vote327 views1 answer
Postgresql get current user name
SQL
1 vote349 views1 answer
Sql server datetime vs datetime2
SQL
1 vote377 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote346 views2 answers
How to create a table from another table in sql derby
SQL