precision and scale functions for numeric

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: precision and scale functions for numeric
Date: 2012-04-29 17:51:37
Message-ID: 1335721897.12058.24.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jay Levitt 2012-04-29 18:01:19 Re: 9.2 release notes, beta time?
Previous Message Peter Eisentraut 2012-04-29 17:48:26 Re: smart shutdown at end of transaction (was: Default mode for shutdown)