Problem with numeric and operators

From: DaVinci <bombadil(at)wanadoo(dot)es>
To: Lista PostgreSql <pgsql-general(at)postgresql(dot)org>
Subject: Problem with numeric and operators
Date: 2001-09-04 12:08:36
Message-ID: 20010904140836.A15151@fangorn.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.

I have a problem with data type 'numeric'. If I have a field of type
'numeric' (in this case 'foo') and execute next query:

select * from table_example where foo > 2.45

I get error:

ERROR: Unable to identify an operator '>' for types 'numeric' and 'float8'
You will have to retype this query using an explicit cast

What is the meaning of this? Is it a bug? What am I doing wrong?...

Thanks.

David

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2001-09-04 12:33:58 Re: Problem with numeric and operators
Previous Message Adam Manock 2001-09-04 11:35:26 Re: PL/java?