Re: proposal: numeric scale functions - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: proposal: numeric scale functions
Date
Msg-id 56434876.8070307@gmx.net
Whole thread Raw
In response to proposal: numeric scale functions  (Marko Tiikkaja <marko@joh.to>)
List pgsql-hackers
On 11/11/15 5:03 AM, Marko Tiikkaja wrote:
> Dealing with "numeric"s right now in cases where it's really important
> that the scale is correct is quite painful.  For example, if I want to
> accept a EUR amount as an input, I often want to reject values such as
> '21.413', but I'd be fine with e.g. '21.410000'.  My suggestion is to
> add two functions: one to return the number of decimal places in a
> numeric, and another one to remove non-significant decimal places.

I can see both of these being useful, but the terminology is not
correct.  The trailing zeroes are "significant".  Maybe the function
could be called "trim", in analogy to trimming whitespace off strings.




pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: can we add SKIP LOCKED to UPDATE?
Next
From: Michael Paquier
Date:
Subject: Re: proposal: multiple psql option -c