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 vote253 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote211 views1 answer
Mysql query to select the highest value
SQL
0 vote192 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote253 views1 answer
How to check event scheduler status mysql
SQL
0 vote183 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
0 vote232 views2 answers
Sql unique
SQL
0 vote202 views1 answer
Count in sql and diff
SQL
0 vote166 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote222 views1 answer
Postgresql create table default value timestamp
SQL
0 vote181 views1 answer
Postgresql default value boolean
SQL