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

From: Christof Petig <christof(at)petig-baender(dot)de>
To: Michael Meskes <meskes(at)postgresql(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: recent ECPG 7.1->7.2 incompatibility ( interval('0sec') = syntax
Date: 2001-11-02 15:58:00
Message-ID: 3BE2C287.8690142A@petig-baender.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Michael Meskes 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)

Christof

PS:
exec sql select date("timestamp"('now'));
is the same

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-11-02 16:50:39 Re: Bug #491: ERROR: RelationClearRelation: relation using JDBC
Previous Message Michael Meskes 2001-11-02 15:20:46 Re: recent ECPG 7.1->7.2 incompatibility ( interval('0sec') = syntax error )