String handling function, substring vs. substr

From: arsi(at)aranzo(dot)netg(dot)se
To: pgsql-general(at)postgresql(dot)org
Subject: String handling function, substring vs. substr
Date: 2006-10-01 20:31:03
Message-ID: Pine.LNX.4.62.0610011453050.22102@aranzo.netg.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message brian 2006-10-01 20:47:33 Re: String handling function, substring vs. substr
Previous Message Bruno Wolff III 2006-09-30 02:56:41 Re: Copy to another server

Browse pgsql-general by date

  From Date Subject
Next Message brian 2006-10-01 20:47:33 Re: String handling function, substring vs. substr
Previous Message Jorge Godoy 2006-10-01 18:48:25 Re: memory issues when running with mod_perl