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 vote102 views1 answer
Oracle current session details
SQL
1 vote92 views1 answer
Sql server 2016 reseed identity
SQL
0 vote91 views1 answer
Mysql with
SQL
0 vote105 views1 answer
Postgres regex word boundary
SQL
0 vote113 views1 answer
View to table sql
SQL
0 vote102 views2 answers
Create sequence if not exists postgres
SQL
0 vote107 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
13 votes100 views6 answers
Current date sql
SQL
23 votes112 views6 answers
Create table sql server
SQL
9 votes98 views1 answer
Sql server get utc date
SQL