Re: Interval resolution

"Geert Jansen" <geert@boskant.nl> writes:
> I'm running PostgreSQL 7.4.6 on RHEL 4 Beta 2. There seems to be a
> bug, or call it inconsistentcy with the documentation, in the
> interval data type. According to
> http://www.postgresql.org/docs/7.4/static/datatype-datetime.html, the
> resolution of interval is 1 microsecond with a range from -178000000
> to 178000000  years. In the example below, this resolution is not
> provided:

See the NOTE below the table.  The documentation does need improvement:
it only discusses precision for timestamp, without making it clear that
this applies to time and interval as well.

            regards, tom lane