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 vote257 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
15 votes200 views2 answers
How to know the username of postgresql
SQL
0 vote197 views1 answer
Postgresql heritage
SQL
10 votes222 views6 answers
Sql between
SQL
0 vote228 views2 answers
Postgres isnull
SQL
1 vote209 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
23 votes214 views6 answers
Create table sql server
SQL
0 vote204 views1 answer
Python mysql query to dataframe
SQL
32 votes235 views6 answers
Rename column mysql
SQL
6 votes239 views1 answer
Identify primary key in oracle table
SQL