String handling function, substring vs. substr

Поиск
Список
Период
Сортировка
Искать
От
arsi@aranzo.netg.se
Тема
String handling function, substring vs. substr
Дата
Msg-id
Pine.LNX.4.62.0610011453050.22102@aranzo.netg.se
Ответ на
Re: autovacuum ignore tables (Sriram Dandapani)
Список
Дерево обсуждения
Re: String handling function, substring vs. substr brian <brian@zijn-digital.com>
Re: String handling function, substring vs. substr Tom Lane <tgl@sss.pgh.pa.us>
Re: String handling function, substring vs. substr arsi@aranzo.netg.se

Hi all,

I want to call one of the two functions above many times (in an aggregate 
function) and it says in the manual pages that substr is the same as 
substring.

Does this mean that substr calls substring internally?? Or is it the other 
way around?? Or are they independent of each other??

So in short, which is faster to use??

Thanks,

Archie
В списке pgsql-general по дате отправления
От: Yannick Warnier
Дата:
Сообщение: GiST and Gin technical doc
От: brian
Дата:
FAQ