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

4 votes110 views1 answer
Wildcard in sql
SQL
0 vote130 views1 answer
Time data type in mysql
SQL
0 vote109 views1 answer
Get enginge db mysql
SQL
0 vote124 views1 answer
Python sqlalchemy connection show server
SQL
0 vote105 views1 answer
Teller stamp , bmo , PDF
SQL
2 votes139 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote127 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
10 votes57 views1 answer
Oracle view dependencies
SQL
20 votes107 views4 answers
Reset auto increment in MySQL
SQL
0 vote105 views1 answer
What is ssrs and ssis in sql server
SQL