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

2 votes308 views1 answer
Sql find missing values between two tables
SQL
5 votes343 views1 answer
How to get all dates in a month in oracle
SQL
0 vote321 views1 answer
Nth max in my sql
SQL
1 vote377 views2 answers
This month mysql where
SQL
0 vote338 views1 answer
Hoq to import database source
SQL
0 vote321 views3 answers
Find below average salary in sql
SQL
10 votes335 views1 answer
User_dependencies
SQL
-1 vote289 views10 answers
Delete Query in SQL Server
SQL
0 vote328 views1 answer
Sql column as header
SQL
0 vote360 views2 answers
Dbms transaction tutorialspoint
SQL