Re: SQL question

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: SQL question
Дата
Msg-id 3972A65A.FBC3E35D@alumni.caltech.edu
обсуждение исходный текст
Ответ на Re: SQL question  (Philip Warner <pjw@rhyme.com.au>)
Ответы Re: SQL question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
> The immediate cause of this gripe was discussed just a day or so ago
> on one or another of the pgsql lists.  The timestamp-to-date conversion
> routine has this weird idea that it should kick out an error instead
> of returning NULL when presented with a NULL timestamp.  That's a bug
> IMHO, and I've already changed the code in current sources.

That's not a bug, that was a feature, sort of. At least when I coded it,
Postgres *refused* to call any routine with NULL input, assuming that
NULL would be returned. A clever short-circuit, and the elog(ERROR) in
the conversion routine was just a safety net. Because it was also the
case that any routine returning a NULL pointer crashed the backend.

Now that those things aren't true, we are rewriting history to say that
they were bugs all along, eh? ;)
                     - Thomas


В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SQL question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: SQL question