Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 107BB2E30F1 for ; Fri, 25 Jan 2008 12:21:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 45707-08 for ; Fri, 25 Jan 2008 12:21:36 -0400 (AST) Received: from mail.ringways.co.uk (hub.ringways.co.uk [80.193.83.130]) by postgresql.org (Postfix) with ESMTP id D6E9A2E2FCB for ; Fri, 25 Jan 2008 12:21:36 -0400 (AST) Received: from eddie.ringways.co.uk ([10.1.1.115]) by mail.ringways.co.uk with esmtp (Exim 4.62) (envelope-from ) id 1JIRCc-0007Sb-R3 for pgsql-sql@postgresql.org; Fri, 25 Jan 2008 16:14:50 +0000 From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-sql@postgresql.org Subject: Re: regex_replace problem -additional Date: Fri, 25 Jan 2008 16:19:43 +0000 User-Agent: KMail/1.9.5 References: <200801251615.59186.gary.stainburn@ringways.co.uk> In-Reply-To: <200801251615.59186.gary.stainburn@ringways.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200801251619.43305.gary.stainburn@ringways.co.uk> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/194 X-Sequence-Number: 30047 Sorry, should have added that I tried type-casting to see if that fixed it. It didn't. Gary goole=# select distinct regex_replace(ud_rfl::text,' *= *'::text,'+'::text) from used_diary where ud_rfl ~ ' *= *'; ERROR: function regex_replace(text, text, text) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. goole=# -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000