Re: cast numeric with scale and precision to numeric plain

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Sim Zacks <sim(at)compulab(dot)co(dot)il>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: cast numeric with scale and precision to numeric plain
Date: 2009-10-20 19:23:07
Message-ID: dcc563d10910201223r17a82790qbafbc6d2f69a7858@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/10/20 Sim Zacks <sim(at)compulab(dot)co(dot)il>:
> I guess that's a matter of interpretation. To me zeros after a decimal
> point without anything else after them are extra.

From a mathematical perspective, they most certainly are not extra.

15.000
15.001
15.002
15.003

Each have three digits of precision, and each mean something here.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2009-10-20 20:46:08 Re: cast numeric with scale and precision to numeric plain
Previous Message Thom Brown 2009-10-20 19:00:19 Re: PostgreSQL driver for Joomla review