Re: BUG #4739: strange behavior of EXTRACT(quarter from INTERVAL) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4739: strange behavior of EXTRACT(quarter from INTERVAL)
Date
Msg-id 26967.1238267645@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #4739: strange behavior of EXTRACT(quarter from INTERVAL)  (Roman Kononov <kononov@ftml.net>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Roman Kononov
Date:
Subject: Re: BUG #4739: strange behavior of EXTRACT(quarter from INTERVAL)
Next
From: "Brice Maron & Duchesne P-A"
Date:
Subject: BUG #4741: Domain constraint violation with trigger