intervals in 7.3.1

From: Jukka Väänänen <jukka(dot)vaananen(at)batman(dot)jypoly(dot)fi>
To: pgsql-general(at)postgresql(dot)org
Subject: intervals in 7.3.1
Date: 2003-01-20 13:20:12
Message-ID: Pine.LNX.4.44.0301201505480.9133-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pablo Yaggi 2003-01-20 13:23:49 Re: Transaction progress
Previous Message mike 2003-01-20 13:06:50 problems configuring with readline and zlib