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 vote178 views2 answers
Homebrew nysql launch
SQL
-1 vote159 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote128 views1 answer
Sqlalchemy filter relationship
SQL
1 vote351 views2 answers
Sql unique rows
SQL
0 vote257 views1 answer
Python mysql check if database exists
SQL
0 vote158 views1 answer
Inser into example
SQL
0 vote169 views1 answer
Php delete database
SQL
3 votes177 views1 answer
Locate sql server
SQL
1 vote171 views1 answer
Oracle undo usage per session
SQL
1 vote241 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL