The following bug has been logged online:
Bug reference: 2037
Logged by: Tom
Email address: lackey(at)ltu(dot)edu
PostgreSQL version: 8.1-beta4
Operating system: Windows XP
Description: user function call unexpected "input out of range"
--No database needs to be selected.
--Just cut and paste into a file.
--All remarks are in comments.
--From the psql prompt use "\i fileName".
create function find (numeric,numeric,numeric,numeric) returns double
drop function find(numeric,numeric,numeric,numeric);
/* This surfaced when calculating the distances between zip codes using
latidtudes and longitudes. When the latitudes and longitudes are the same
the distance should be zero. Number 1 gives the error. Number 2 differs by a
digit in the last decimal place and works. Number 3 is another test with
identical latitudes and longitudes and does calculate zero.
The "DROP FUNCTION" was only put in so I could repeatly re-execute the
The ".msi" was used for the install accepting all of the defaults.
pgsql-bugs by date
|Next:||From: apple sucks||Date: 2005-11-12 02:55:14|
|Subject: dyld: Library not loaded: /server_sw/lib/libpq.4.dylib|
|Previous:||From: Reuben Pasquini||Date: 2005-11-11 02:26:55|
|Subject: BUG #2036: 8.1 JDBC busted date with INTERVAL update|