[SQL] SQL function to validate money input

[Zhao, Scott]

Title: Message

Hi All,

 

Is there a function available to validate if the input is a correct money format? For exapmle, "23.56" is a correct number but "23.567" is incorrect. I just like to do this in postgres level not in my application code.

 

Thanks

 

Scott