Bugs item #1000567, was opened at 2006-02-24 10:23
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000567&group_id=1000125
Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: Discrepant results versus other connections
Initial Comment:
I've found a case where psqlODBC doesn't match JODBC, psql, or Perl-DBD::Pg. It looks like a numeric/floating point
issueperhaps?
Using psqlodbc-08.00.0100 and psqlodbc-08.01.0200. Both compiled as 64bit, Postgres 8.0.1.
Sample code:
CREATE OR REPLACE FUNCTION plpgsql_multiply(numeric, float) RETURNS numeric AS $$
DECLARE
BEGIN
RETURN $1 * $2;
END
$$ LANGUAGE plpgsql;
CREATE OR REPLACE FUNCTION perl_ge(numeric, float) RETURNS bool AS $$
if ($_[0] >= $_[1]) { return true; }
return false;
$$ LANGUAGE plperl;
SELECT perl_ge(47.3, plpgsql_multiply(43, 1.1));
-- true using JODBC, DBD::Pg, psql
-- false using ODBC
----------------------------------------------------------------------
Comment By: Bryce Baril (vaticide)
Date: 2006-03-06 08:54
Message:
I'm using iSQL for testing, but the problem was discovered using SAS.
In iSQL I simply use the SELECT statement above to get the result, if that is what you are asking.
----------------------------------------------------------------------
Comment By: Hiroshi Inoue (hinoue)
Date: 2006-03-01 15:40
Message:
How are you calling the function concretely using ODBC ?
----------------------------------------------------------------------
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000567&group_id=1000125