Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group