intervals in 7.3.1

Поиск
Список
Период
Сортировка
Искать
От
Jukka Väänänen
Тема
intervals in 7.3.1
Дата
Msg-id
Pine.LNX.4.44.0301201505480.9133-100000@localhost.localdomain
Список
Дерево обсуждения
intervals in 7.3.1 Jukka Väänänen <jukka.vaananen@batman.jypoly.fi>
Re: intervals in 7.3.1 Tom Lane <tgl@sss.pgh.pa.us>

Hi,

I have been using intervals in postgresql like this:

  select interval('2 weeks');

We upgraded to 7.3.1 and now this produces error:

  ERROR:  parser: parse error at or near "'2 weeks'" at character 17

this works ok:

  select '2 weeks'::interval;

this also:

  select date(current_timestamp);

Is this a bug or is installation gone terribly wrong or is it a new 
policy? Should I change all interval('xxx') to 'xxx'::interval?

-Jukka


В списке pgsql-general по дате отправления
От: mike
Дата:
От: Chris Boget
Дата:
FAQ