| 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: | Whole Thread | Raw Message | 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 ? |