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

2 votes365 views1 answer
Oracle trace file
SQL
1 vote324 views1 answer
Clear screen command in psql
SQL
0 vote327 views1 answer
Sql server convert date to weekday
SQL
0 vote345 views3 answers
Osx stop mysql service
SQL
0 vote352 views2 answers
Oracle ora-00054 how to unlock
SQL
14 votes357 views1 answer
Excel
SQL
10 votes351 views1 answer
Oracle dependencies table
SQL
2 votes349 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
8 votes318 views1 answer
Oracle find text in functions
SQL
0 vote329 views1 answer
Google cloud sql postgres url example
SQL