Comparison Operator problem
От | John Burski |
---|---|
Тема | Comparison Operator problem |
Дата | |
Msg-id | 3A5B7F86.E83F4BFE@911ep.com обсуждение исходный текст |
Ответы |
Re: Comparison Operator problem
|
Список | pgsql-novice |
I was working on a small "lesson" at home last night when I encountered a strange problem with both the greater-than and greater-than-or-equal-to comparison operators. Below are both the description of the table I was running the query against, the one of the queries that caused the problem, and the error message it produced. <snip> Table "products_tbl" Attribute | Type | Modifier -----------+--------------+---------- prod_id | varchar(10) | not null prod_desc | varchar(40) | not null cost | numeric(6,2) | not null Index: products_tbl_pkey john=# select * from products_tbl john-# where cost > .99; ERROR: Unable to identify an operator '>' for types 'numeric' and 'float8' You will have to retype this query using an explicit cast </snip> I did a "\do" to take a look at the available operators. Both of them were there for both "numeric" and "float8". I should mention that I'm running 7.0.3 on Red Hat 6.1. It was installed via RPMs. Thanks. -- John Burski Chief IT Cook and Bottlewasher 911 Emergency Products, St. Cloud, MN (320) 656 0076 www.911ep.com ++++++++++++++++++++++++++++++++++ + How's your cheese holding out? + ++++++++++++++++++++++++++++++++++
В списке pgsql-novice по дате отправления: