Re: String handling function, substring vs. substr

Поиск
Список
Период
Сортировка
От arsi@aranzo.netg.se
Тема Re: String handling function, substring vs. substr
Дата
Msg-id Pine.LNX.4.62.0610021856320.28792@aranzo.netg.se
обсуждение исходный текст
Ответ на Re: String handling function, substring vs. substr  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi all,

> 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
>
Thanks Brian for your answer (although that wasn't what I was looking for,
I was looking for Tom's answer).

Thanks Tom for your answer.

Archie

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Postgres backup
Следующее
От: Alexander Staubo
Дата:
Сообщение: Re: Weird disk write load caused by PostgreSQL?