Re: BUG #4739: strange behavior of EXTRACT(quarter from INTERVAL)

Roman Kononov <kononov@ftml.net> writes:
> On 2009-03-28 11:34 Tom Lane said the following:
>> If you have an actual use-case for this, what do you think it should do?

> I don't have a use-case (other than hypothetical "how many more years
> and quarters did it take to complete this particular software project
> than that particular project"). I think that a quarter is 1/4 year and
> that is it.

That's not really helpful for determining which way to round fractions.
I think we'll leave this alone until someone has a real use-case that
can guide the decision.

            regards, tom lane