Database Reference
In-Depth Information
type casts.
hannu=# select add(VARIADIC ARRAY[1,2,NULL]);
-[ RECORD 1 ]
add | 3
You can even smuggle in a multi-dimensional array:
hannu=#
select
add(VARIADIC '{{1,2,3},{4,5,6}}');
.
ERROR: 1-dimensional array needed
This calling convention also means that even when you create
VARIADIC
functions
you need to check the array dimensions.