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

1 vote368 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote453 views1 answer
Drop table BigQuery table columns
SQL
0 vote351 views1 answer
Tsql find procedure with name
SQL
3 votes360 views1 answer
Force using index oracle
SQL
39 votes411 views5 answers
Sql drop column
SQL
2 votes358 views1 answer
Sql OR
SQL
1 vote366 views1 answer
Sql order by where condition
SQL
11 votes324 views1 answer
Reset identity sql server
SQL
5 votes345 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote388 views1 answer
Get statis values sql
SQL