On Mon, 2010-10-25 at 12:20 -0500, Kevin Grittner wrote:
> It would be very useful to be able to specify a granularity -- for
> example timestamps with a five minute granularity would be useful
> for scheduling appointments. In some cases the granularity might be
> inferred -- if we have a domain defined as numeric(13,2), it would
> be nice if the default granularity was 0.01::numeric.
I don't think typmod really helps us much. It's more a property of the
column than the type.
To specify different granularities, I don't think we can avoid
specifying new types with their own entries in pg_type.
Regards,
Jeff Davis