| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Chapman Flack <chap(at)anastigmatix(dot)net> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: 'infinity'::Interval should be added |
| Date: | 2018-12-13 15:08:03 |
| Message-ID: | 10302.1544713683@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Chapman Flack <chap(at)anastigmatix(dot)net> writes:
> On 12/13/18 04:41, Simon Riggs wrote:
>> [ we should allow this: ]
>> SELECT 'infinity'::interval;
>> ERROR: invalid input syntax for type interval: "infinity"
> ... and if that is made to work, perhaps then arithmetic should be
> updated as well,
That wouldn't be optional. All built-in functions on interval
would *have* to be updated to deal sanely with the new values.
(Fortunately, there aren't that many of them, IIRC.)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | chjischj@163.com | 2018-12-13 15:12:04 | Re:Connections hang indefinitely while taking a gin index's LWLock buffer_content lock |
| Previous Message | Tom Lane | 2018-12-13 15:05:42 | Re: BUG #15548: Unaccent does not remove combining diacritical characters |