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 vote261 views1 answer
Oracle step procedure
SQL
7 votes248 views1 answer
Query delete duplicates
SQL
0 vote266 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote254 views1 answer
Initcap in sql
SQL
0 vote248 views1 answer
Format the money fied with comma in international system using sql
SQL
8 votes277 views1 answer
Oracle add datafile to tablespace
SQL
23 votes258 views3 answers
Mysqldump
SQL
4 votes263 views3 answers
How to describe a table in sqlite3
SQL
4 votes270 views1 answer
Phone number sql
SQL
2 votes283 views1 answer
Merge firstname and lastname in sql oracle
SQL