[RFE] Add MAX_INT constants

[robrwo]

It would be nice to have a :max set of constants to import, so that code could use these to validate numeric types before passing them into queries, e.g.

use constant MIN_SMALLINT => -32768;
use constant MAX_SMALLINT => 32767;
use constant MIN_INT  => -2147483648;
use constant MAX_INT => 2147483647;
...

I'm unsure how to handle bigints for this, though.

See https://www.postgresql.org/docs/11/datatype-numeric.html

[turnstep]

I'm fine with this idea. Although a quick implementation attempt has revealed an issue in how we do our exporting, so will have to wait until I can circle back to it.

[turnstep]

Okay, did some cleanup and implemented a proof of concept here: 5298fac

[robrwo]

Thanks, this looks good.

[turnstep]

Closing: this is live now; added in 3.9.0