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?
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.