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 vote157 views1 answer
Postgresql inheritance
SQL
1 vote147 views1 answer
Mysql remove last empty newline
SQL
1 vote134 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote167 views1 answer
Check constraint is violated
SQL
0 vote153 views1 answer
Postgresql array to rows
SQL
11 votes152 views1 answer
Creating tables in sql with python
SQL
25 votes146 views6 answers
Modify column name in mysql
SQL
16 votes154 views6 answers
Insert sql
SQL
0 vote106 views1 answer
Mysql select top 2
SQL
0 vote136 views1 answer
Postgresql add not null and not empty constraint
SQL