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

1 vote130 views1 answer
Access the postgres psql
SQL
0 vote123 views1 answer
See the structure of a table mysql
SQL
0 vote184 views1 answer
Oracle temporary table
SQL
-1 vote163 views1 answer
Mysql faster insert
SQL
0 vote126 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
2 votes83 views2 answers
Mysql get last character of string
SQL
0 vote140 views1 answer
Drop unique
SQL
0 vote125 views1 answer
Transaction database with php
SQL
0 vote119 views1 answer
List mysql tables and views
SQL
0 vote111 views1 answer
Create api project in visual studio 2019 and sql server
SQL