Re: 7.2 -> 7.3 timespan, interval etc.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 7.2 -> 7.3 timespan, interval etc.
Дата
Msg-id 262.1054793073@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 7.2 -> 7.3 timespan, interval etc.  (Nabil Sayegh <postgresql@e-trolley.de>)
Ответы Re: 7.2 -> 7.3 timespan, interval etc.  (Nabil Sayegh <postgresql@e-trolley.de>)
Список pgsql-novice
Nabil Sayegh <postgresql@e-trolley.de> writes:
> Some of our projects (7.2) use timespan() which for example evaluates:
> SELECT timespan('5 seconds');
>  interval
> ----------
>  @ 5 secs

Oh?  I get

regression=# SELECT timespan('5 seconds');
 interval
----------
 00:00:05
(1 row)

in 7.0, 7.1, and 7.2.  I see this in the 7.0 release notes:

    * The date/time types datetime and timespan have been superseded by
       the SQL92-defined types timestamp and interval. Although there has
       been some effort to ease the transition by allowing PostgreSQL to
       recognize the deprecated type names and translate them to the new
       type names, this mechanism may not be completely transparent to
       your existing application.

            regards, tom lane

В списке pgsql-novice по дате отправления:

Предыдущее
От: Nabil Sayegh
Дата:
Сообщение: 7.2 -> 7.3 timespan, interval etc.
Следующее
От: root
Дата:
Сообщение: Re: locale support ?