Re: bigint out of range

On 5/18/19 3:49 PM, Peter J. Holzer wrote:

On 2019-05-18 15:19:22 -0500, Ron wrote:

On 5/18/19 2:27 PM, Peter J. Holzer wrote:

On 2019-05-18 10:49:53 -0700, David G. Johnston wrote:

You don’t perform math on a hash

That's not generally true. Hashes are used for further computation for
example in hash tables or in cryptography.

How is it "using math" to use a hash key in a hash lookup table?

hash modulo table size.

I've seen that used when the tablespace is pre-allocated, and you hash modulo the tablespace page number.  (Yes, performance tanks when you start filling up pages.)  How do you hash on the (ever growing) table size?