Answers for "postgresql array functions"

SQL
1

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
Posted by: Guest on October-30-2021
1

postgresql append array

array_append(anyarray, anyelement);
Posted by: Guest on November-24-2020

Code answers related to "postgresql array functions"

Code answers related to "SQL"

Browse Popular Code Answers by Language