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

6 votes265 views1 answer
To count number of rows in SQL table
SQL
0 vote304 views1 answer
Primary key start from number
SQL
0 vote338 views1 answer
Trigger
SQL
0 vote263 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
0 vote282 views1 answer
Query string starts with vowels
SQL
0 vote288 views1 answer
ORA-13717
SQL
0 vote294 views2 answers
Replace null with 0 in sql
SQL
2 votes285 views2 answers
Storing timezones in postgres
SQL
0 vote261 views1 answer
Sql select most frequent value in group
SQL
0 vote269 views1 answer
Android sqlite get rows count
SQL