Re: Strange plpgsql performance, diff plperl and plpgsql

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Strange plpgsql performance, diff plperl and plpgsql
Дата
Msg-id 13741.1112576538@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Strange plpgsql performance, diff plperl and plpgsql  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
Список pgsql-general
Pavel Stehule <stehule@kix.fsv.cvut.cz> writes:
> the array from speed2 is ok, but array from speed is mal formated.

They both look OK to me.

> I declare all function as numeric(7,2)[]

Type modifiers applied to function arguments and results are generally
ignored.  What you have here is functions returning numeric[], and not
anything else.  In the plpgsql example the coercion to numeric(7,2)
happens because you stored into a local variable declared that way,
but there's nothing to make it happen in the plperl example.

            regards, tom lane

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

Предыдущее
От: Tony Caduto
Дата:
Сообщение: Question about format_type function
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Strange plpgsql performance -- arithmetic, numeric() type, arrays