intervals in 7.3.1 - Mailing list pgsql-general

From Jukka Väänänen
Subject intervals in 7.3.1
Date
Msg-id Pine.LNX.4.44.0301201505480.9133-100000@localhost.localdomain
Whole thread Raw
Responses Re: intervals in 7.3.1
List pgsql-general
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 by date:

Previous
From: mike
Date:
Subject: problems configuring with readline and zlib
Next
From: "Chris Boget"
Date:
Subject: Altering a table - positioning new columns