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

3 votes183 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote178 views1 answer
Oracle synonym procedure
SQL
0 vote178 views1 answer
Postgres call view
SQL
0 vote182 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote221 views1 answer
Sql multiple into
SQL
0 vote199 views1 answer
Sql server isnull function nor working count
SQL
0 vote180 views1 answer
Mysql count by month
SQL
2 votes170 views1 answer
Mysql auto increment jumping
SQL
0 vote215 views1 answer
What is common table expression in sql
SQL
0 vote203 views1 answer
USING THE NOT CONDITION IN SQL
SQL