"Geert Jansen" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]