Home > mailing lists

SQL function to validate money input - Mailing list pgsql-sql

From	Zhao, Scott
Subject	SQL function to validate money input
Date	October 15, 2003 23:19:52
Msg-id	8A45A0F766A7C34894C80BBAEBEBA118E0AC7E@thick.usask.ca Whole thread Raw
Responses	Re: SQL function to validate money input (Richard Huxton <dev@archonet.com>)
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: Josh Berkus
Date: 15 October 2003, 22:18:24
Subject: Re: Calc

From: Wilson Fletcher
Date: 16 October 2003, 03:28:54
Subject: convert integer seconds to timestamp

SQL function to validate money input - Mailing list pgsql-sql

Previous

Next