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 vote164 views1 answer
Postgresql log
SQL
0 vote156 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote146 views1 answer
18446744073709551615 mariadb left join order by
SQL
1 vote147 views1 answer
ALL_TAB_PARTITIONS
SQL
5 votes152 views3 answers
Postgres show databases
SQL
10 votes140 views4 answers
Join with multiple conditions sql
SQL
8 votes146 views2 answers
Update sql server from another table
SQL
2 votes139 views2 answers
Compare date mysql
SQL
7 votes161 views1 answer
Oracle reset sequence
SQL
0 vote280 views1 answer
Mysql delete entire row on condition
SQL