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 vote298 views1 answer
Sqlcl format
SQL
31 votes263 views3 answers
Sql count
SQL
3 votes281 views3 answers
List columns in table postgres
SQL
16 votes284 views4 answers
Find duplicates mysql
SQL
0 vote266 views1 answer
Mysql show foreign keys column
SQL
0 vote283 views1 answer
Where name ends in SQL
SQL
1 vote265 views1 answer
Create sqlite database in laravel
SQL
0 vote301 views1 answer
Default order by in mysql
SQL
0 vote312 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote315 views1 answer
Stored procedure function relation
SQL