Re: Proposed patch: make SQL interval-literal syntax work per spec - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Proposed patch: make SQL interval-literal syntax work per spec
Date
Msg-id 48C877EB.8010901@agliodbs.com
Whole thread Raw
In response to Re: Proposed patch: make SQL interval-literal syntax work per spec  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
> (1)  In the spec, an interval value or literal must be either
> year-month or day-time.  (I guess they didn't want to try to deal with
> the sticky issues of what it means to have an interval of, for
> example, seven months and three days -- since an interval has no sense
> of which seven months.)

Note that, for usability reasons, Karel some time ago try-partitioned 
our intervals: year-month|day-week|hour-min-sec.

--Josh



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Interesting glitch in autovacuum
Next
From: "Pavan Deolasee"
Date:
Subject: Re: Interesting glitch in autovacuum