Received: from thor.tht.net (thor.tht.net [209.47.145.4]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAUKR2F04595 for ; Thu, 30 Nov 2000 15:27:02 -0500 (EST) (envelope-from jellis@advocast.com) Received: from thor.advocast.com (advocast18.dsl.inconnect.com.76.140.209.in-addr.arpa [209.140.76.44] (may be forged)) by thor.tht.net (8.9.3/8.9.3) with ESMTP id PAA95188 for ; Thu, 30 Nov 2000 15:49:29 GMT (envelope-from jellis@advocast.com) Received: from advocast83 (unknown [192.168.0.13]) by thor.advocast.com (Postfix) with SMTP id 5BBB480323 for ; Thu, 30 Nov 2000 15:59:32 -0700 (MST) Message-ID: <017c01c05b05$5729dfa0$0d00a8c0@dsl.inconnect.com> From: "Jonathan Ellis" To: References: <5.0.2.1.2.20001130113826.082b4ec0@pop.mindspring.com><3A268A5C.91CB7353@wgcr.org> <14886.40191.455322.734798@onceler.kciLink.com> Subject: String function page incorrect? Date: Thu, 30 Nov 2000 12:40:01 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200011/291 X-Sequence-Number: 322 I'm trying to find the correct function that returns the location of a substring within a string. Looking at http://www.postgresql.org/docs/user/x2731.htm, it gives the Function name as "textpos" but in the Example column it uses "position". But neither one works! bf2=# select position('high', 'ig'); ERROR: parser: parse error at or near "," bf2=# select textpos('high', 'ig'); ERROR: Function 'textpos(unknown, unknown)' does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts bf2=# select textpos(text('high'), text('ig')); ERROR: Function 'textpos(text, text)' does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts ??? -Jonathan