Postgres Pro
Downloads
Home   >   mailing lists

NUMERIC and arithmetics - Mailing list pgsql-general

From Christoph Dalitz
Subject NUMERIC and arithmetics
Date
Msg-id 20020919142721.5213b546.christoph.dalitz@hs-niederrhein.de
Whole thread Raw
Responses Re: NUMERIC and arithmetics  (Martijn van Oosterhout <kleptog@svana.org>)
Re: NUMERIC and arithmetics  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Hello,

in PG 7.1.x the NUMERIC data type makes some trouble with arithmetic and comparison
operators:

    delete from produkt where preis > 3.00;

yields

    ERROR:  Unable to identify an operator '>' for types 'numeric' and 'float8'

preis is typed NUMERIC(8,2). Strangely, "preis > 3" works.

Is this fixed in version 7.2?

Thanks,

Christoph Dalitz

pgsql-general by date:

Previous
From: Jochem van Dieten
Date:
Subject: Re: IN vs EXIIST
Next
From: Andrew Sullivan
Date:
Subject: Re: IN vs EXIIST