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

From Alexandr
Subject Re: QSoC proposal: date_trunc supporting intervals
Date
Msg-id 532B4F0B.9000401@gmail.com
Whole thread Raw
In response to Re: QSoC proposal: date_trunc supporting intervals  (Josh Berkus <josh@agliodbs.com>)
List 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 by date:

Previous
From: Thom Brown
Date:
Subject: Re: QSoC proposal: date_trunc supporting intervals
Next
From: Josh Berkus
Date:
Subject: Re: QSoC proposal: date_trunc supporting intervals