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
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 |
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 ? |