Re: [SQL] SQL function to validate money input

2003-10-16 Thread Richard Huxton
On Wednesday 15 October 2003 22:46, Zhao, Scott wrote: > 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. Well

[SQL] SQL function to validate money input

2003-10-15 Thread 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