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 по дате отправления: