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 votes290 views1 answer
Two selects in one query
SQL
11 votes353 views2 answers
Import mysql dump command line windows
SQL
0 vote305 views1 answer
Mariadb cast null to 0
SQL
0 vote293 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote279 views1 answer
Truncate table sql server foreign key
SQL
3 votes298 views1 answer
Stpop start psql server
SQL
0 vote289 views1 answer
How to open mysql in docker
SQL
5 votes311 views1 answer
Invalid column name sql
SQL
0 vote293 views1 answer
Select last N rows mysql
SQL
2 votes298 views1 answer
Set column to not null mysql
SQL