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 vote257 views2 answers
Coursera spark sql max count
SQL
4 votes226 views2 answers
Error loading MySQLdb module.
SQL
0 vote207 views1 answer
Sql random decimal
SQL
0 vote220 views1 answer
What is the use of index in mysql table
SQL
0 vote263 views1 answer
Show all sequences postgres
SQL
0 vote227 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
1 vote227 views1 answer
Postgres delete from where date is greater than specific date
SQL
1 vote232 views7 answers
Filter
SQL
1 vote229 views2 answers
Drop table if exists test
SQL
0 vote230 views1 answer
Mariadb date equals to current_date plus days
SQL