| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Geert Jansen" <geert(at)boskant(dot)nl> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Interval resolution |
| Date: | 2005-01-17 18:32:51 |
| Message-ID: | 4298.1105986771@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"Geert Jansen" <geert(at)boskant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-01-17 18:51:26 | Re: psql 8.0.0 rc5 parser error on \dt? |
| Previous Message | Dave Bodenstab | 2005-01-17 17:31:00 | psql 8.0.0 rc5 parser error on \dt? |