Re: String handling function, substring vs. substr

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: String handling function, substring vs. substr
Дата
Msg-id 4834.1159742510@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: String handling function, substring vs. substr  (brian <brian@zijn-digital.com>)
Ответы Re: String handling function, substring vs. substr  (arsi@aranzo.netg.se)
Список pgsql-general
brian <brian@zijn-digital.com> writes:
> arsi@aranzo.netg.se wrote:
>> Does this mean that substr calls substring internally?? Or is it the
>> other way around?? Or are they independent of each other??

> Looks like they're pretty evenly matched.

Actually, a bit of poking into the contents of pg_proc will show you
that they are both aliases for the same C function (text_substr_no_len).
So they should be *exactly* the same speed.

            regards, tom lane

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

Предыдущее
От: brian
Дата:
Сообщение: Re: String handling function, substring vs. substr
Следующее
От: "rlee0001"
Дата:
Сообщение: Normal vs Surrogate Primary Keys...