fortnight interval support
| От | Nathan Wagner |
|---|---|
| Тема | fortnight interval support |
| Дата | |
| Msg-id | 20151027135211.GA690@granicus.if.org обсуждение исходный текст |
| Ответ на | Re: Proposal: Trigonometric functions in degrees (Robert Haas <robertmhaas@gmail.com>) |
| Ответы |
Re: fortnight interval support
Re: fortnight interval support Re: fortnight interval support Re: fortnight interval support |
| Список | pgsql-hackers |
On Mon, Oct 26, 2015 at 01:58:52PM -0400, Robert Haas wrote:
> Aw, you're no fun. select '1 fortnight'::interval => '14 days' would be cool.
Patch attached...
:)
% psql -p 5433 -d template1 -h localhost
psql (9.4.5, server 9.6devel)
WARNING: psql major version 9.4, server major version 9.6.
Some psql features might not work.
Type "help" for help.
template1=# select current_date;
date
------------
2015-10-27
(1 row)
template1=# select '1 fortnight'::interval;
interval
----------
14 days
(1 row)
template1=# select current_date + '1 fortnight'::interval;
?column?
---------------------
2015-11-10 00:00:00
(1 row)
template1=# select current_date + '1.3 fortnight'::interval;
?column?
---------------------
2015-11-14 04:48:00
(1 row)
template1=# select current_date + '1.3 fortnights'::interval;
?column?
---------------------
2015-11-14 04:48:00
(1 row)
--
nw
Вложения
В списке pgsql-hackers по дате отправления: