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 vote146 views1 answer
Strat with in sql
SQL
51 votes265 views6 answers
Opera gx
SQL
11 votes167 views2 answers
How to import mysql database command line
SQL
1 vote146 views1 answer
Select statement to print longest name
SQL
16 votes154 views1 answer
Mysql reset auto increment value
SQL
0 vote165 views1 answer
Oracle sql add column auto generated value
SQL
0 vote161 views1 answer
Rename view mysql
SQL
0 vote158 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote161 views1 answer
Order by with where clause in mysql
SQL
7 votes163 views2 answers
3rd height salary sql
SQL