| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Consistency problem with unlabeled intervals |
| Date: | 2002-05-03 02:01:46 |
| Message-ID: | 2897.1020391306@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Thomas Lockhart <lockhart(at)fourpalms(dot)org> writes:
>> That is, '60' is read as so many hours, '1.5' is read as so many
>> seconds. This seems a tad inconsistent.
> They fulfill two separate use cases. Time zones can now be specified as
> intervals, and the default unit must be hours. A number with a decimal
> point is usually in units of seconds, and matches past behavior afaik.
Hm. Well, if this behavior is intentional, it'd be nice to document it.
The existing paragraphs about interval's I/O format don't mention
behavior for unitless numbers at all, much less explain that a decimal
point has semantic significance.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Mercer | 2002-05-03 02:29:17 | Re: PostgreSQL mission statement? |
| Previous Message | mlw | 2002-05-03 01:45:45 | Re: PostgreSQL mission statement? |