Re: QSoC proposal: date_trunc supporting intervals

Поиск
Список
Период
Сортировка
От Alexandr
Тема Re: QSoC proposal: date_trunc supporting intervals
Дата
Msg-id 532B4F0B.9000401@gmail.com
обсуждение исходный текст
Ответ на Re: QSoC proposal: date_trunc supporting intervals  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
<br /><div class="moz-cite-prefix">21.03.2014 00:07, Josh Berkus пишет:<br /></div><blockquote
cite="mid:532B4A69.6060103@agliodbs.com"type="cite"> Per my comments on the GSOC app, it looks good, but I'd like to
seesome "stretch goals" if you are able to implement the new function before GSOC is over. For example, one thing which
hasbeen frequently requested is functions to display intervals in the unit of your choice ... for example, convert "1
day"to "14400 seconds". Pick some stretch goals which work for you ... but I'd like to see some. </blockquote> I looked
throughTODO and found only 2 ideas with intervals:<br /><span style="color: rgb(0, 0, 0); font-family: sans-serif;
font-size:16px; font-style: normal; font-variant: normal;     font-weight: normal; letter-spacing: normal; line-height:
   24.28874969482422px; orphans: auto; text-align: start;     text-indent: 0px; text-transform: none; white-space:
normal;    widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;     background-color: rgb(255, 255, 255);
display:inline !important;     float: none;">1) Allow infinite intervals just like infinite timestamps<br /> 2) </span>
<spanstyle="color: rgb(0, 0, 0); font-family: sans-serif;     font-size: 16px; font-style: normal; font-variant:
normal;    font-weight: normal; letter-spacing: normal; line-height:     24.28874969482422px; orphans: auto;
text-align:start;     text-indent: 0px; text-transform: none; white-space: normal;     widows: auto; word-spacing: 0px;
-webkit-text-stroke-width:0px;     background-color: rgb(255, 255, 255); display: inline !important;     float:
none;">Havetimestamp subtraction not call justify_hours() (formatting intervals with to_chars)<br /> I want to add
theseideas as stretch goals:<br /> 1) extract_total() - </span>allows conversation of the interval to a total number of
theuser's desired unit<br /><span style="color: rgb(0, 0, 0); font-family: sans-serif;     font-size: 16px; font-style:
normal;font-variant: normal;     font-weight: normal; letter-spacing: normal; line-height:     24.28874969482422px;
orphans:auto; text-align: start;     text-indent: 0px; text-transform: none; white-space: normal;     widows: auto;
word-spacing:0px; -webkit-text-stroke-width: 0px;     background-color: rgb(255, 255, 255); display: inline !important;
   float: none;"> 2) Allow TIMESTAMP WITH TIME ZONE<br /> 3) add function to allow the creation of timestamps using
parameters<br/> 4) Add function to detect if an array is empty<br /> Josh, what do you think about them?<br /></span> 

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

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: QSoC proposal: date_trunc supporting intervals
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: QSoC proposal: date_trunc supporting intervals