Re: BUG #4918: Weird input syntax for intervals
| От | Tom Lane |
|---|---|
| Тема | Re: BUG #4918: Weird input syntax for intervals |
| Дата | |
| Msg-id | 27901.1247511422@sss.pgh.pa.us обсуждение |
| Ответ на | BUG #4918: Weird input syntax for intervals ("Frank Spies" <frank.spies@biotronik.com>) |
| Ответы |
Re: BUG #4918: Weird input syntax for intervals
Re: BUG #4918: Weird input syntax for intervals |
| Список | pgsql-bugs |
"Frank Spies" <frank.spies@biotronik.com> writes:
> It feels totally weird that the two queries
> 1) select interval '13 month'
> 2) select interval '13' month
> do not have the same result: result for 1) is "1 year 1 mon", result for 2
> is "1 mon". Is this correct behaviour?
$ psql
psql (8.4.0)
Type "help" for help.
regression=# select interval '13 month';
interval
--------------
1 year 1 mon
(1 row)
regression=# select interval '13' month;
interval
--------------
1 year 1 mon
(1 row)
You sure you are on 8.4.0? We were fooling with the interval input code
quite late in 8.4 beta.
regards, tom lane
В списке pgsql-bugs по дате отправления: