From: | <noreply(at)pgfoundry(dot)org> |
---|---|
To: | noreply(at)pgfoundry(dot)org |
Subject: | [ psqlodbc-Bugs-1000567 ] Discrepant results versus other connections |
Date: | 2006-02-24 18:23:16 |
Message-ID: | 20060224182316.BD6941033827@pgfoundry.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Bugs item #1000567, was opened at 2006-02-24 18: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 issue perhaps?
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
----------------------------------------------------------------------
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000567&group_id=1000125
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2006-02-25 22:44:55 | [ psqlodbc-Bugs-1000569 ] Mispelling - Advanced Options p. 1 |
Previous Message | richard.hardgrave | 2006-02-24 17:34:57 | Installing my PostgreSQL client |