Re: make_interval ??

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: make_interval ??
Дата
Msg-id CAFj8pRBT3jmiGNWQZrhBPA0cr4XfF5+OKHqiwSxBLyCoeo4AQg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: make_interval ??  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
Hello

here is patch

postgres=# select make_interval(years := 1, months := 6);
 make_interval
---------------
 1 year 6 mons
(1 row)

postgres=# select make_interval(weeks := 3);
 make_interval
---------------
 21 days
(1 row)

postgres=# select make_interval(days := 10);
 make_interval
---------------
 10 days
(1 row)

postgres=# select make_interval(hours := 2, mins := 10, secs := 25.33);
 make_interval
---------------
 02:10:25.33
(1 row)

Regards

Pavel


2013/12/21 Josh Berkus <josh@agliodbs.com>
On 12/20/2013 04:44 PM, Gavin Flower wrote:
> On 21/12/13 13:40, Josh Berkus wrote:
>> On 12/20/2013 03:09 PM, Gavin Flower wrote:
>>> What about leap years?
>> What about them?
>>
> some years have 365 days others have 366, so how any days in an interval
> of 2 years?, 4 years?

Your question isn't relevant to this patch.  It's not defining the
interval type, just creating an alternate constructor for it.

(the answer is, it depends on what timestamp you're adding it to ...)

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: INSERT...ON DUPLICATE KEY LOCK FOR UPDATE
Следующее
От: Fabien COELHO
Дата:
Сообщение: ISN extension bug?