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 vote230 views1 answer
Sql column as header
SQL
2 votes254 views2 answers
Mysql add hours to time field
SQL
0 vote228 views1 answer
Update one column from another column in same table
SQL
7 votes233 views1 answer
Postgres base size
SQL
2 votes239 views1 answer
Mysql Incorrect column specifier for column
SQL
5 votes222 views3 answers
Truncate function in sql oracle
SQL
0 vote206 views2 answers
Influxdb delete measurement based on date
SQL
0 vote237 views1 answer
Mysql undo delete
SQL
1 vote231 views1 answer
Mysql pretty date format
SQL
0 vote238 views1 answer
Postgres reorder columns
SQL