Error using between on a numeric

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

In response to

Browse pgsql-hackers by date

  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