From: ivan <ivan>
Date: Mon, 7 Jul 2008 21:38:49 +0000 (+0000)
Subject: SQL_FLOAT is probably unnecessary and causes probelms on old (v1.x?) DBD::Pg
X-Git-Tag: root_of_webpay_support~504
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=104972679d3122d6fcba9e137cb951d161d08a2e

SQL_FLOAT is probably unnecessary and causes probelms on old (v1.x?) DBD::Pg
---

diff --git a/FS/FS/Record.pm b/FS/FS/Record.pm
index 730d81afe..c2b128463 100644
--- a/FS/FS/Record.pm
+++ b/FS/FS/Record.pm
@@ -308,12 +308,14 @@ sub qsearch {
     my $TYPE = SQL_VARCHAR;
     if ( $type =~ /(int|(big)?serial)/i && $value =~ /^\d+(\.\d+)?$/ ) {
       $TYPE = SQL_INTEGER;
-    } elsif (    ( $type =~ /(numeric)/i     && $value =~ /^[+-]?\d+(\.\d+)?$/)
-              || ( $type =~ /(real|float4)/i
-                     && $value =~ /[-+]?\d*\.?\d+([eE][-+]?\d+)?/
-                 )
-            ) {
-      $TYPE = SQL_FLOAT;
+
+    #DBD::Pg 1.49: Cannot bind ... unknown sql_type 6
+    #} elsif (    ( $type =~ /(numeric)/i     && $value =~ /^[+-]?\d+(\.\d+)?$/)
+    #          || ( $type =~ /(real|float4)/i
+    #                 && $value =~ /[-+]?\d*\.?\d+([eE][-+]?\d+)?/
+    #             )
+    #        ) {
+    #  $TYPE = SQL_FLOAT;
     }
 
     if ( $DEBUG > 2 ) {