NUMERIC and arithmetics

From: Christoph Dalitz <christoph(dot)dalitz(at)hs-niederrhein(dot)de>
To: PG Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: NUMERIC and arithmetics
Date: 2002-09-19 12:27:21
Message-ID: 20020919142721.5213b546.christoph.dalitz@hs-niederrhein.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Bowlby 2002-09-19 12:37:56 array issue....
Previous Message Ben-Nes Michael 2002-09-19 12:06:42 pg_dump in 7.1.3 and migration to 7.2.2