Unable to convert null timestamp to date. Bug?

From: "Edmar Wiggers" <edmar(at)brasmap(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Unable to convert null timestamp to date. Bug?
Date: 2000-12-07 23:08:09
Message-ID: NEBBIAKDCDHFGJMLHCKIMEPKCBAA.edmar@brasmap.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-sql


Strange, this works:
select * from users where last_visit > now() + 7;
-- last_visit is nullable, of type timestamp

But this doesn't
select * from users where last_visit + 7 > now();
ERROR: Unable to convert null timestamp to date
-- yes, there are users where last_visit IS NULL

BTW, this works too:
select null+1; -- obviously returns NULL

System is FreeBSD 4.1, PgSQL 7.0.2

Anyone got a clue?

Yours sincerely,

Edmar Wiggers
BRASMAP Information Systems
+55 48 9960 2752

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2000-12-08 01:01:51 Re: [SQL] Unable to convert null timestamp to date. Bug?
Previous Message Ricardo Dias Marques 2000-12-07 17:51:59 Re: pg_dump backup problems with password authentication

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-12-07 23:31:54 Re: trying to pattern match to a value contained in a column
Previous Message Jie Liang 2000-12-07 23:01:56 Re: how to execute a C program via trigger ?