Re: Interval resolution - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Interval resolution
Date
Msg-id 4298.1105986771@sss.pgh.pa.us
Whole thread Raw
In response to Interval resolution  ("Geert Jansen" <geert@boskant.nl>)
List pgsql-bugs
"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

pgsql-bugs by date:

Previous
From: amorati
Date:
Subject: Trigger changes visibility
Next
From: Tom Lane
Date:
Subject: Re: psql 8.0.0 rc5 parser error on \dt?