Simon Riggs <simon@2ndQuadrant.com> writes:
> I would like it even more if there was a data type specific default.
> Currently we have a special case for boolean, but that's it.
No, we don't (or if we do I'd be interested to know where). I don't see
much value in a data-type-dependent default anyway --- would you make
different defaults for int4, int8, and float8, and on what grounds?
The actual data contents of three such columns could easily be exactly
equivalent.
regards, tom lane