Is it possible for mysql function to accept null data types on input?

Vote count:

1

like in this false example:

CREATE FUNCTION my_func(arg1 INT NULL, arg2 INT NULL)
...

So for example would be possible to have logic react to situation where in db there is column with integers that could be zero, positive, negative or null (so I can't have a value to collate null into, zero is meanigful) which means that data is not available and the function should return null on output when some arguments are unknown but do a slightly modified version of algorithm when only part of data is available in the row.

or maybe there is function overloading like in C++ ? so I could write multiple functions:

CREATE FUNCTION my_func(arg1 NULL, arg2 INT)
...
CREATE FUNCTION my_func(arg1 INT, arg2 NULL)
...

asked 1 min ago

rsk82

3,888