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 vote195 views4 answers
What is unique key in sql
SQL
2 votes192 views1 answer
How to delete columns in sql
SQL
0 vote172 views1 answer
Pl sql search saurce code
SQL
0 vote184 views2 answers
Jsonb
SQL
0 vote176 views1 answer
Update one column from another column in same table
SQL
0 vote193 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote181 views1 answer
Sql add calculated column
SQL
3 votes188 views2 answers
Postgres download
SQL
0 vote165 views1 answer
Rollback to name in sql
SQL
1 vote180 views1 answer
Access the postgres psql
SQL