precision and scale functions for numeric - Mailing list pgsql-hackers

From Peter Eisentraut
Subject precision and scale functions for numeric
Date
Msg-id 1335721897.12058.24.camel@vanquo.pezone.net
Whole thread Raw
Responses Re: precision and scale functions for numeric  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
I didn't find a good way to find out how many digits a numeric value has
or things like whether a numeric value is an integer.  (I had to go
through bc(1) for the latter.)  Functions like precision() and scale()
would have been quite handy.  Are there other ways to do this, or would
this make a good addition?



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: smart shutdown at end of transaction (was: Default mode for shutdown)
Next
From: Jay Levitt
Date:
Subject: Re: 9.2 release notes, beta time?