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

13 votes137 views3 answers
Sql online code
SQL
5 votes127 views1 answer
Mysql select greater than yesterday
SQL
4 votes138 views2 answers
How to insert ip address in mysql using php
SQL
1 vote126 views1 answer
Sql restore backup query
SQL
1 vote140 views1 answer
Display total number of tables in mysql
SQL
0 vote131 views1 answer
Sql case sttement with set
SQL
0 vote184 views1 answer
Selecting specific day in colum sql
SQL
13 votes135 views3 answers
Insert mysql ifile nto database
SQL
0 vote133 views1 answer
How to see the query of a view in mysql
SQL
0 vote151 views1 answer
Sql query inline if
SQL