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 vote343 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
2 votes382 views1 answer
Ssh mysql port forwarding
SQL
16 votes328 views3 answers
Jwt secret key generator laravel
SQL
4 votes328 views2 answers
How to insert ip address in mysql using php
SQL
-1 vote327 views1 answer
How to switch user in mysql
SQL
7 votes305 views1 answer
Grant schema permissions postgres
SQL
0 vote544 views1 answer
Get first match in each group mysql query
SQL
0 vote313 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote323 views1 answer
Fast sql column count
SQL
1 vote309 views1 answer
How to print longest name in sql
SQL