This approach makes a lot more sense. The real problem here is input validation, not type mismatch. Arguably, this could extend to real numerical data (use NUM

This approach makes a lot more sense. The real problem here is input validation, not type mismatch. Arguably, this could extend to real numerical data (use NUMERIC everywhere as a default), but the performance impacts of that are far more severe.