Re: Issue with partitioning - legitimate insert fails with no partition message

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

 



> On Sep 30, 2022, at 9:21 AM, Sbob <sbob@xxxxxxxxxxxxxxxxxxxxx> wrote:
> 
> It seems that the range for partitions is inclusive of the starting value and exclusive of the ending value, maybe this is documented and I missed it?

Yes, it is. (and "to" is not "through")

The explanation is: think of a floating-point value, if it included the end value would you use XXX.999, or XXX.9999, or XXX.99999... Same argument applies to timestamps--even though they are stored as 64-bit integers, how would you figure out the value that is 1 bit less than your end date?








[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux