X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 13EBBD1B537 for ; Wed, 15 Oct 2003 23:19:51 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 67304-02 for ; Wed, 15 Oct 2003 20:19:22 -0300 (ADT) Received: from skyway.usask.ca (skyway.usask.ca [128.233.192.232]) by svr1.postgresql.org (Postfix) with ESMTP id 77ED8D1B538 for ; Wed, 15 Oct 2003 20:19:18 -0300 (ADT) Received: from CONVERSION-DAEMON.sask.usask.ca by sask.usask.ca (PMDF V6.2-X17 #30663) id <01L1V5UEISEO9524OO@sask.usask.ca> for pgsql-sql@postgresql.org; Wed, 15 Oct 2003 17:09:39 -0600 (CST) Received: from abysm.usask.ca ([128.233.192.230]) by sask.usask.ca (PMDF V6.2-X17 #30663) with ESMTP id <01L1V5TU939U95553T@sask.usask.ca> for pgsql-sql@postgresql.org; Wed, 15 Oct 2003 17:08:40 -0600 (CST) Received: from CONVERSION-DAEMON.abysm.usask.ca by abysm.usask.ca (PMDF V6.2-X17 #30663) id <01L1V2ZGG2PC90AFHK@abysm.usask.ca> for pgsql-sql@postgresql.org; Wed, 15 Oct 2003 15:47:07 -0600 (CST) Received: from thick.usask.ca ([128.233.193.248]) by abysm.usask.ca (PMDF V6.2-X17 #30663) with ESMTP id <01L1V2YRMCWI90A6QV@abysm.usask.ca> for pgsql-sql@postgresql.org; Wed, 15 Oct 2003 15:46:09 -0600 (CST) Date: Wed, 15 Oct 2003 15:46:07 -0600 From: "Zhao, Scott" Subject: SQL function to validate money input To: pgsql-sql@postgresql.org Message-id: <8A45A0F766A7C34894C80BBAEBEBA118E0AC7E@thick.usask.ca> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft Exchange V6.0.6487.1 Content-type: multipart/alternative; boundary="Boundary_(ID_u3QySJNiC7woHnPQMQyU5A)" Thread-Topic: SQL function to validate money input Thread-Index: AcOTZb2GYXDpvQ4cQxqPY0sWl7Mhbw== content-class: urn:content-classes:message X-MS-Has-Attach: X-MS-TNEF-Correlator: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/183 X-Sequence-Number: 15583 This is a multi-part message in MIME format. --Boundary_(ID_u3QySJNiC7woHnPQMQyU5A) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT 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 --Boundary_(ID_u3QySJNiC7woHnPQMQyU5A) Content-type: text/html; charset=us-ascii Content-transfer-encoding: QUOTED-PRINTABLE =0D Message=0D = =0D =0D =0D
Hi =0D All,
=0D
 
=0D
Is there = a function =0D available to validate if the input is a correct money format? For= =0D exapmle, "23.56" is a correct number but "23.567" is incorrect. I just like= to =0D do this in postgres level not in my application code.
= =0D
 
=0D
Thanks = =0D
=0D
 
=0D
Scott
=0D
 
=0D =00 --Boundary_(ID_u3QySJNiC7woHnPQMQyU5A)--