On Mon, 28 Apr 2003 15:09:46 -0700 (PDT)
Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> wrote:
Actually, that was the last thing I tried before I wrote this note. Before I entered
herboris=> INSERT INTO cart (cartid, clientid, invdate, paydate) VALUES
herboris-> (4469858, 2, 'current', 'now');
And still got the same error message:
ERROR: Bad date external representation 'current'
> On Mon, 28 Apr 2003, Mark Tessier wrote:
> > When I try to insert with the "current" constant, as in:
> > herboris=> INSERT INTO cart (cartid, clientid, invdate, paydate) VALUES
> > herboris-> (4469858, 2, 'current_timestamp', 'now');
> > I get the following message:
> > ERROR: Bad date external representation 'current_timestamp'
> current_timestamp shouldn't be quoted AFAIK. It's trying to read the
> string current_timestamp as a date value.
In response to
pgsql-general by date
|Next:||From: Stephan Szabo||Date: 2003-04-29 03:26:11|
|Subject: Re: Bad timestamp external representation|
|Previous:||From: Dennis Gearon||Date: 2003-04-28 23:58:33|
|Subject: Re: Bug(?) with cursors using aggregate functions.|