SQL function to validate money input

From: "Zhao, Scott" <scott(dot)zhao(at)usask(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: SQL function to validate money input
Date: 2003-10-15 21:46:07
Message-ID: 8A45A0F766A7C34894C80BBAEBEBA118E0AC7E@thick.usask.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2003-10-15 22:15:43 Re: Calc
Previous Message Christopher Browne 2003-10-15 21:31:21 Re: indexing timestamp fields