On 03/20/2014 01:26 PM, Alexandr wrote: > > 21.03.2014 00:07, Josh Berkus пишет: >> Per my comments on the GSOC app, it looks good, but I'd like to see >> some "stretch goals" if you are able to implement the new function >> before GSOC is over. For example, one thing which has been 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. > I looked through TODO and found only 2 ideas with intervals: > 1) Allow infinite intervals just like infinite timestamps > 2) Have timestamp subtraction not call justify_hours() (formatting > intervals with to_chars) > I want to add these ideas as stretch goals: > 1) extract_total() - allows conversation of the interval to a total > number of the user's desired unit > 2) Allow TIMESTAMP WITH TIME ZONE > 3) add function to allow the creation of timestamps using parameters > 4) Add function to detect if an array is empty > Josh, what do you think about them?
Comments: #2: I don't understand this one? #3 is already a patch for version 9.4, but possibly you can improve/expand it. #4 has already been the subject of a LOT of debate, I think you don't want to get into it. -- 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
