bug or change in functionality in 7.2? - Mailing list pgsql-general

From Barry Lind
Subject bug or change in functionality in 7.2?
Date
Msg-id 3BF4712B.4040606@xythos.com
Whole thread Raw
Responses Re: [HACKERS] bug or change in functionality in 7.2?
List pgsql-general
I have in my code a SQL statement that does the following:

select period_start + interval('1 hour') from periods;

This worked in 7.1, but in 7.2 I am getting the following error:

ERROR:  parser: parse error at or near "'"

If I remove the quotes then I get the following error:

ERROR:  parser: parse error at or near "hour"

Was this change from 7.1 to 7.2 intentional?  If so, how should this be
coded in 7.2?

thanks,
--Barry


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: 7.2 pg_hba.conf load on SIGHUP?
Next
From: Tom Lane
Date:
Subject: Re: 7.2 pg_hba.conf load on SIGHUP?