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 votes200 views1 answer
Set default today mysql
SQL
0 vote163 views1 answer
Sql server alter table column nullable
SQL
1 vote365 views2 answers
Coderbyte sql solutions
SQL
5 votes182 views1 answer
Oracle asynchronous update
SQL
10 votes138 views2 answers
Sql where clause multiple values
SQL
8 votes155 views2 answers
Phpmyadmin password
SQL
0 vote179 views1 answer
Sql out file formate
SQL
0 vote172 views4 answers
Sql rownum
SQL
0 vote169 views1 answer
Typeorm raw sql
SQL
0 vote174 views1 answer
Insert ip address in mysql
SQL