From 104972679d3122d6fcba9e137cb951d161d08a2e Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 7 Jul 2008 21:38:49 +0000 Subject: [PATCH] SQL_FLOAT is probably unnecessary and causes probelms on old (v1.x?) DBD::Pg --- FS/FS/Record.pm | 14 ++++++++------ 1 file changed, 8 insertions(+), 6 deletions(-) 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 ) { -- 2.11.0