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

11 votes139 views1 answer
How to get ddl for materialized view
SQL
14 votes155 views1 answer
Excel is not a database
SQL
0 vote165 views1 answer
Edit shchima table in sql
SQL
2 votes143 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote161 views1 answer
Except in sql
SQL
0 vote128 views1 answer
Metada in sql
SQL
0 vote150 views1 answer
How to get one year old query from plan cache
SQL
0 vote130 views1 answer
Update having mysql
SQL
0 vote96 views1 answer
Calculate discount from original price sql
SQL
1 vote197 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL