Re: recent ECPG 7.1->7.2 incompatibility ( interval('0sec') = syntax error ) - Mailing list pgsql-bugs

From Michael Meskes
Subject Re: recent ECPG 7.1->7.2 incompatibility ( interval('0sec') = syntax error )
Date
Msg-id 20011102204019.A1483@feivel.fam-meskes.de
Whole thread Raw
In response to Re: recent ECPG 7.1->7.2 incompatibility ( interval('0sec') = syntax  (Christof Petig <christof@petig-baender.de>)
List pgsql-bugs
On Fri, Nov 02, 2001 at 04:58:00PM +0100, Christof Petig wrote:
> > > cast ( some_timestamp_var as date), '0sec'::interval   and   "timestamp"
> > > (date_var, time_var)  still work but if this is just an oversight, I'd
> >
> > You mean it works with quotes but not without?
>
> Yes:
>
> exec sql select "interval"('0sec');  // accepted by ecpg
> exec sql select interval('0sec');     // not accepted by ecpg (yesterday's
> CVS)

Not really surprising I guess since "interval" is accepted as the string
>interval< while interval is regarded a token.

Michael
--
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #508: update not atomic
Next
From: Bruno Wolff III
Date:
Subject: Referential integrity checking issue