bug or change in functionality in 7.2?

From: Barry Lind <barry(at)xythos(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: bug or change in functionality in 7.2?
Date: 2001-11-16 01:51:39
Message-ID: 3BF4712B.4040606@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Muir 2001-11-16 02:02:25 FW: Vacuuming - how often? (scott's fault?)
Previous Message Doug McNaught 2001-11-16 01:39:04 Re: pgsql and large tables

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2001-11-16 02:58:06 Re: bug or change in functionality in 7.2?
Previous Message Tatsuo Ishii 2001-11-16 01:08:18 Re: [HACKERS] [PHP] PostgreSQL / PHP Overrun Error