Error using between on a numeric
От | Dave Cramer |
---|---|
Тема | Error using between on a numeric |
Дата | |
Msg-id | 007001c17db7$fac1da20$8201a8c0@inspiron обсуждение исходный текст |
Ответ на | Re: SunOS4 port (Karel Zak <zakkr@zf.jcu.cz>) |
Список | 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
В списке pgsql-hackers по дате отправления: