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