An interesting feature in PostgreSQL is the ability to easily pass arrays to functions. In our example we’re going to pass in an array to a PostgreSQL function, print out each of the array values and exit the function. We’ll see how easy it is to pass and parse in PostgreSQL.
Here’s our function. Notice the “_int4” input parameter to demonstrate an Integer Array.
Here’s our select:
select count_by_two(ARRAY [4,7,15,18]);
And our output:
I told you it was easy…