Error using between on a numeric - Mailing list pgsql-hackers

Hi,

I am trying to debug something on the jdbc list and can't figure out
what is going on here

I'm running postgres 7.1.3 on linux

Here's the table

CREATE TABLE "savingsaccount" (  "id" varchar(3) NOT NULL,  "firstname" varchar(24),  "lastname" varchar(24),
"balance"numeric(10,2),  CONSTRAINT "pk_savings_account" PRIMARY KEY ("id")
 
);

If I do the select from my machine I get this in the logs

2001-12-05 12:51:47 [3210]   DEBUG:  query: select id from
savingsaccount where balance between 1 and 200
2001-12-05 12:51:47 [3210]   DEBUG:  ProcessQuery
2

There is another program running on another machine which get's this
result??


2001-12-05 12:33:56 [3156]   DEBUG:  query: select id from
savingsaccount where balance between 1.00 and 5.00
2001-12-05 12:33:56 [3156]   ERROR:  Unable to identify an operator '>='
for types 'numeric' and 'float8'

I even tried with decimals

2001-12-05 12:55:27 [3220]   DEBUG:  query: select id from
savingsaccount where balance between
0.900000000000000022204460492503130808472
63336181640625 and 199.900000000000005684341886080801486968994140625
2001-12-05 12:55:27 [3220]   DEBUG:  ProcessQuery
2

Anyone have a clue what's going on here?

Dave