Robert Haas wrote:
> The advantage of specifying a + and a - in the type interface is that
> the unit definition can then be specified as part of the type
> declaration itself. So you can do:
>
> CREATE TYPE ts_sec AS RANGE OVER timestamp (UNIT = '1s');
> CREATE TYPE ts_min AS RANGE OVER timestamp (UNIT = '1m');
>
The problem with mixing units with ranges is that units are properties
of some underlying datatype but not all types on which ranges can be
defined.
regards,
Yeb Havinga
