String handling function, substring vs. substr - Mailing list pgsql-general

From arsi@aranzo.netg.se
Subject String handling function, substring vs. substr
Date
Msg-id Pine.LNX.4.62.0610011453050.22102@aranzo.netg.se
Whole thread Raw
Responses Re: String handling function, substring vs. substr  (brian <brian@zijn-digital.com>)
List pgsql-general
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 by date:

Previous
From: Yannick Warnier
Date:
Subject: GiST and Gin technical doc
Next
From: brian
Date:
Subject: Re: String handling function, substring vs. substr