Re: final light versions of Oracle compatibility (SQLSTATE, GREATEST,

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: final light versions of Oracle compatibility (SQLSTATE, GREATEST,
Дата
Msg-id 12643.1118335154@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: final light versions of Oracle compatibility (SQLSTATE, GREATEST,  (Neil Conway <neilc@samurai.com>)
Ответы Re: final light versions of Oracle compatibility (SQLSTATE,  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: final light versions of Oracle compatibility (SQLSTATE,  (Neil Conway <neilc@samurai.com>)
Список pgsql-patches
Neil Conway <neilc@samurai.com> writes:
> Attached is a revised version of this patch. I'll apply it tonight or
> tomorrow, barring any objections.

I still find the grammar changes to be an ugly kluge --- it should be
possible to do this without introducing bogus nonterminals.

The ns push/pop operations don't appear to be correctly matched
(consider multiple WHEN clauses, a case the regression test does not
cover), nor do they surround the places where the variables are created.
It is likely that you don't need a push/pop at all; if it appears to
work now it's because the end of the block results in a pop and so
the variables disappear then anyway.

The patch is sloppy about whether free_var() is static or not.

I find the proposed change in plpgsql_ns_additem a distinct
disimprovement --- it's dubious even as a micro-optimization
and it certainly hurts legibility.

            regards, tom lane

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: to_timestamp overloaded to convert from Unix epoch
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: final light versions of Oracle compatibility (SQLSTATE,