Re: IS NULL
| От | Tom Lane |
|---|---|
| Тема | Re: IS NULL |
| Дата | |
| Msg-id | 6387.1005165087@sss.pgh.pa.us обсуждение |
| Ответ на | Re: IS NULL (David Link <dlink@soundscan.com>) |
| Список | pgsql-novice |
David Link <dlink@soundscan.com> writes:
>> This is a bug. What version are you using? Could you supply
>> an exact example of a value that makes it crash?
> pg 7.0.3 (running on mandrake 8.0 / 2.4.3 kernal)
Okay, I've looked at the CVS logs and I believe you are stumbling over
some nasty little bugs in the 7.0.* versions of to_timestamp (which is
invoked by to_date) and to_char. I would strongly recommend an upgrade
to 7.1.*. In particular, 7.0's to_timestamp has the ugly habit of
scribbling on its input data, which is bad news in any case but
particularly so when applied directly to a table column :-(. If you
use it in 7.0 you are very likely to suffer unrecoverable data loss.
regards, tom lane
В списке pgsql-novice по дате отправления: