Skip site navigation (1) Skip section navigation (2)

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

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Christof Petig <christof(at)petig-baender(dot)de>
Cc: Michael Meskes <meskes(at)postgresql(dot)org>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: recent ECPG 7.1->7.2 incompatibility ( interval('0sec') = syntax error )
Date: 2001-11-02 19:40:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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 Meskes
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!

In response to


pgsql-bugs by date

Next:From: Tom LaneDate: 2001-11-02 20:42:43
Subject: Re: New default ignored by pre-exising insert rulesets.
Previous:From: Tom LaneDate: 2001-11-02 16:50:39
Subject: Re: Bug #491: ERROR: RelationClearRelation: relation using JDBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group