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
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 |
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 |