Re: Date = current_timestamp inconsistency?

From: "Peter Gibbs" <peter(at)emkel(dot)co(dot)za>
To: "Jean-Christian Imbeault" <jc(at)mega-bucks(dot)co(dot)jp>, "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Date = current_timestamp inconsistency?
Date: 2003-04-18 08:29:51
Message-ID: 001601c30584$ae69d820$0b01010a@emkel.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jean-Christian Imbeault wrote:

> TEST=# select ('2003-04-18'::date=current_timestamp::date);
> t
> TEST=# insert into t values('2003-04-08');
> TEST=# select (d=current_timestamp::date) from t;
> f

I'm not sure why you expect the 8th and 18th of April to be equal anyway??

--
Peter Gibbs
EmKel Systems

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeffrey Melloy 2003-04-18 08:48:41 Documentation
Previous Message Benjamin RICHARD 2003-04-18 08:16:11 Problem with the use of Array and Loop