error codes for ln(), power()

Поиск
Список
Период
Сортировка
От Neil Conway
Тема error codes for ln(), power()
Дата
Msg-id 1084603429.25578.99.camel@tokyo
обсуждение исходный текст
Ответы Re: error codes for ln(), power()  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
SQL2003 mandates that ln() and power() emit particular SQLSTATE error
codes for a few illegal combinations of arguments (in Section 6.27 of my
copy of SQL2003). This patch adds those error codes and changes the
several variants of ln() and power() to emit them as appropriate.

I didn't change log() to emit the same error code as ln() when it is
passed similarly incorrect arguments, on the grounds that the SQLSTATE
code defined by SQL specifically refers to the "natural logarithm". Does
anyone think I should make both log() and ln() return the same SQLSTATE
code, invent a new SQLSTATE for log() errors, and just leave things as
they are? (the latter being my preference...)

I didn't bother adding any regression tests for this behavior, but I can
do so if anyone thinks that's worth doing.

Barring any objections, I intend to apply this patch within 24 hours.

-Neil


Вложения

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_ctl patch to integrate apache's rotatelogs
Следующее
От: Neil Conway
Дата:
Сообщение: Re: nested transactions