Tom Lane-2 wrote
>
>> -- A stored procedure which can accept two argument, which can be a
>> single
>> integer field, or an array of integers.
>
> Those two cases seem unlikely to be supportable by the same
> implementation, so it seems more likely that what you'd be doing is just
> overloading the function name with two instances, my_fn(int) and
> my_fn(int[]).
Isn't this scenario why VARIDIC was implemented:
CREATE FUNCTION my_fn( VARIADIC in_ordered_actual varchar[] ) ....
The single value input is simply a special case of an array of size 1.
Depending on whether you allow an empty array you might want to:
CREATE FUNCTION my_fn(required_first varchar, VARIADIC optional_others
varchar[] DEFAULT '{}'::varchar[]) ...
Then join the two values together and move on to processing.
You would still need separate functions for numbers versus strings.
David J.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Semi-Pseudo-Data-Types-Procedure-Arguments-tp5761158p5761173.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.