details: /erp/devel/pi/rev/6fbfcf8888d6
changeset: 8786:6fbfcf8888d6
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Tue Nov 02 18:08:06 2010 +0100
summary: Fixes issue 0015008: Wrong behaviour with 9 Decimals
It has been modified the TO_NUMBER function to accept up to 10 decimals instead
of 6 decimals
diffstat:
src-db/database/model/prescript-PostgreSql.sql | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (21 lines):
diff -r 87e52d35324f -r 6fbfcf8888d6
src-db/database/model/prescript-PostgreSql.sql
--- a/src-db/database/model/prescript-PostgreSql.sql Tue Nov 02 17:53:24
2010 +0100
+++ b/src-db/database/model/prescript-PostgreSql.sql Tue Nov 02 18:08:06
2010 +0100
@@ -167,7 +167,7 @@
)
RETURNS NUMERIC AS '
BEGIN
-RETURN to_number($1, ''S99999999999999D999999'');
+RETURN to_number($1, ''S99999999999999D9999999999'');
EXCEPTION
WHEN OTHERS THEN
RETURN NULL;
@@ -193,7 +193,7 @@
RETURNS "numeric" AS
$BODY$
BEGIN
-RETURN to_number($1, 'S99999999999999D999999');
+RETURN to_number($1, 'S99999999999999D9999999999');
EXCEPTION
WHEN OTHERS THEN
RETURN NULL;
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
