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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Roman Kononov <kononov(at)ftml(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4739: strange behavior of EXTRACT(quarter from INTERVAL)
Date: 2009-03-28 19:14:05
Message-ID: 26967.1238267645@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Roman Kononov <kononov(at)ftml(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Brice Maron & Duchesne P-A 2009-03-30 14:20:24 BUG #4741: Domain constraint violation with trigger
Previous Message Roman Kononov 2009-03-28 16:52:21 Re: BUG #4739: strange behavior of EXTRACT(quarter from INTERVAL)