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

From arsi@aranzo.netg.se
Subject Re: String handling function, substring vs. substr
Date
Msg-id Pine.LNX.4.62.0610021856320.28792@aranzo.netg.se
Whole thread Raw
In response to Re: String handling function, substring vs. substr  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Postgres backup
Next
From: Alexander Staubo
Date:
Subject: Re: Weird disk write load caused by PostgreSQL?