Skip site navigation (1) Skip section navigation (2)

SQL error 'Unable to identify an operator = for type numeric?'

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: SQL error 'Unable to identify an operator = for type numeric?'
Date: 2002-03-07 20:01:12
Message-ID: OF64FBA054.BCFAF8CC-ON88256B75.006AD67C@fds.com (view raw or flat)
Thread:
Lists: pgsql-novice
I have table defined as such:

Create Table t1
(
f1 int,
f2 numeric (13,2)
)

insert into t1 values (1,12.22);
insert into t1 values (2,12);

if I do the following query I receive data:

Select  * from t1 where f2 = 12;

If I do the following I get
Unablel to identify an operator '=' for types 'numeric' and 'double
precision'  You will have to retype this query using an
explicit cast:

Select  * from t1 where f2 = 12.22;

If I put single quotes around '12.22' it works.  I must be using the wrong
data type

What data type do I need to set instead of MONEY?  Should I use FLOAT8?

Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-932-0610 office




Responses

pgsql-novice by date

Next:From: BrianDate: 2002-03-07 20:08:29
Subject: starting the postmaster
Previous:From: Jon HassenDate: 2002-03-07 19:37:37
Subject: Re: index item size 4496 exceeds maximum 2713

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group