Postgres Pro
Downloads
Home   >   mailing lists

Cast double precision to integer & check for overflow - Mailing list pgsql-general

From Ian Pilcher
Subject Cast double precision to integer & check for overflow
Date
Msg-id ke1gtm$jbk$1@ger.gmane.org
Whole thread Raw
Responses Re: Cast double precision to integer & check for overflow  (Gavan Schneider <pg-gts@snkmail.com>)
List pgsql-general
Tree view 
I need to cast a double precision into an integer, and I want to check
that the value will actually fit (modulo rounding).

Coming from a C/Java background, this seems like something that should
be utterly trivial.  In my searching, however, I can't seem to find any
SQL equivalent of INT_MAX, Integer.MAX_VALUE, etc.

Do I have to hard-code this value?

Thanks!

(And yes, I do feel stupid having to ask this question here.)

--
========================================================================
Ian Pilcher                                         arequipeno@gmail.com
Sometimes there's nothing left to do but crash and burn...or die trying.
========================================================================

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Range for user-defined SQLSTATE codes
Next
From: "Alexander Gataric"
Date:
Subject: Re: [GENERAL] Cast double precision to integer & check for overflow