Re: QSoC proposal: date_trunc supporting intervals - Mailing list pgsql-hackers

From Claudio Freire
Subject Re: QSoC proposal: date_trunc supporting intervals
Date
Msg-id CAGTBQpaP6JCSoMw06oMExagksCpuSmqBfy3jQDWJFgP88XB6dg@mail.gmail.com
Whole thread Raw
In response to Re: QSoC proposal: date_trunc supporting intervals  (Alexandr <askellio@gmail.com>)
List pgsql-hackers
On Thu, Mar 20, 2014 at 5:55 PM, Alexandr <askellio@gmail.com> wrote:
>> Subtracting to get an interval, then converting that interval to seconds
>> or minutes could give you a value that's wildly different from the right
>> answer.
>
> Can you explain me when it happens ?


'1 month'::interval

It's different depending on which month we're talking about.



pgsql-hackers by date:

Previous
From: Alexandr
Date:
Subject: Re: QSoC proposal: date_trunc supporting intervals
Next
From: "Behn, Edward (EBEHN)"
Date:
Subject: Array of composite types returned from python