Chris Angelico <rosuav@xxxxxxxxx> writes: > Or alternatively, does PostgreSQL have any integer type larger than > 64-bit bigint? I've become accustomed to using bignums in most of my > programming; arbitrary-precision integers allow all sorts of handy > flexibilities. Are there any plans to add bignums (something like > GMP's mpz) to the engine? It's hard to muster much excitement about that when we've already got "numeric". As far as the OP's problem goes, I wonder if there wouldn't be some use in an inet+(big)int function that does shift-and-add, ie move the integer over by the number of bits that have to remain zero according to the netmask. I'm not seeing the use for adding enormous random integers to IP addresses --- but "three over from this /64 block" doesn't seem so improbable. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
