Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group