I have a function like so:
update_stuff_variadic(
VARIADIC _stuff_array stuff[]
)
I understand that this syntax requires _stuff_array to match the column structure of the stuff[] table.
Instead of implicitly matching every column of the stuff table, is it possible to set the required type of the elements in the array?
Pseudo:
update_stuff_variadic(
VARIADIC _stuff_array array['comment'::BIGINT, 'created_by'::TEXT]
)
This way the array passed to the function doesn't have to accommodate for columns such as serial id fields, or auto-populated fields such as timestamps.