Search Postgresql Archives

Re: Question about integer out of range in function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Condor <condor@xxxxxxxxxx> writes:
>       new_time = fromtime * 1000; -- here is line 19

Are you entirely certain that you counted lines correctly?
If new_time and fromtime are both declared bigint, and
fromtime is on the order of

# select extract(epoch from now())::bigint;
  extract   
------------
 1621003124
(1 row)

then there's no way that that statement fails on integer overflow.

What I'm wondering about is the next line:

>       unix_time = (new_time + rand_int)::BIGINT;

You've not shown us the declaration of unix_time ...

			regards, tom lane





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux