Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 2AE399FB2CC for ; Sun, 1 Oct 2006 17:32:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 21582-10 for ; Sun, 1 Oct 2006 17:32:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 779659FA2B9 for ; Sun, 1 Oct 2006 17:32:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from aranzo.netg.se (aranzo.netg.se [212.91.141.40]) by svr4.postgresql.org (Postfix) with ESMTP id 863125AF032 for ; Sun, 1 Oct 2006 20:32:50 +0000 (GMT) Received: from arsi (helo=localhost) by aranzo.netg.se with local-esmtp (Exim 4.50) id 1GU7xn-00066e-D6 for pgsql-general@postgresql.org; Sun, 01 Oct 2006 22:31:03 +0200 Date: Sun, 1 Oct 2006 22:31:03 +0200 (CEST) From: arsi@aranzo.netg.se To: pgsql-general@postgresql.org Subject: String handling function, substring vs. substr In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF060E5C9B@ca-mail1.cis.local> Message-ID: References: <6992E470F12A444BB787B5C937B9D4DF060E5C9B@ca-mail1.cis.local> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.975 tagged_above=0 required=5 tests=AWL, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200610/22 X-Sequence-Number: 101549 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