From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Barry Lind" <barry(at)xythos(dot)com> |
Cc: | "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: bug or change in functionality in 7.2? |
Date: | 2001-11-16 02:58:06 |
Message-ID: | GNELIHDDFBOCMGBFGEFOOEHBCAAA.chriskl@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Well, the way I've always constructed these queries is:
select period_start + interval '1 hour' from periods;
Try that. In fact, I believe the above is the correct SQL standard syntax?
Chris
> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org]On Behalf Of Barry Lind
> Sent: Friday, 16 November 2001 9:52 AM
> To: pgsql-general(at)postgresql(dot)org
> Cc: PostgreSQL-development
> Subject: [HACKERS] bug or change in functionality in 7.2?
>
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-11-16 04:42:35 | Re: 7.2 pg_hba.conf load on SIGHUP? |
Previous Message | Bruce Momjian | 2001-11-16 02:25:58 | Re: 7.2 pg_hba.conf load on SIGHUP? |
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Studenmund | 2001-11-16 03:33:25 | Re: Open items |
Previous Message | Barry Lind | 2001-11-16 01:51:39 | bug or change in functionality in 7.2? |