From: | "Dave Cramer" <dave(at)fastcrypt(dot)com> |
---|---|
To: | |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Error using between on a numeric |
Date: | 2001-12-05 18:09:28 |
Message-ID: | 007001c17db7$fac1da20$8201a8c0@inspiron |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Doug McNaught | 2001-12-05 18:17:39 | Licensing |
Previous Message | Bruce Momjian | 2001-12-05 17:51:12 | Re: SunOS4 port |