Re: Maximum limit on int in plpgsql

deepthi@granwill.com wrote:
> The i am taking the sum using this formula
> 
> out_sum=ip1*256*256*256+ip2*256*256+ip3*256+ip4;
> 
> When i run the procedure i am getting following error
> pg_atoi : Numerical result out of range
> 
> I tried all possible datatypes but still i am getting the same error.
> 
> Is it the problem of typecasting or the limits on datatype?

Type integer=int4 and is signed. IP addresses are unsigned. You'll need 
to use an int8 to hold them.

-- 
   Richard Huxton
   Archonet Ltd