Re: Range Types, discrete and/or continuous - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Range Types, discrete and/or continuous
Date
Msg-id 1288029716.8645.4.camel@jdavis-ux.asterdata.local
Whole thread Raw
In response to Re: Range Types, discrete and/or continuous  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Range Types, discrete and/or continuous
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: ask for review of MERGE
Next
From: "David E. Wheeler"
Date:
Subject: Re: add label to enum syntax