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 vote203 views1 answer
How to to get current date in sql
SQL
1 vote221 views2 answers
Mysql between
SQL
0 vote267 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote183 views1 answer
How to get initials in sql
SQL
8 votes228 views1 answer
Mysql restore database
SQL
3 votes187 views2 answers
Mysql create database
SQL
0 vote201 views1 answer
Sql dmv to capture updates
SQL
1 vote192 views1 answer
Sql select all from one table and one column from another
SQL
3 votes214 views3 answers
Mysql order by list
SQL
53 votes583 views6 answers
Sql server alter column
SQL