Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 08BB42E2FCB for ; Fri, 25 Jan 2008 12:29:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 75092-10 for ; Fri, 25 Jan 2008 12:29:32 -0400 (AST) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.234]) by postgresql.org (Postfix) with ESMTP id D4D6A2E2F32 for ; Fri, 25 Jan 2008 12:29:31 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 58so439139wri.10 for ; Fri, 25 Jan 2008 08:29:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=v/eOXxJF3TkFeS48P//ePW5S1LLXdRm2K6KWmoFWDj8=; b=kI5fGeMcNGtBnp3YE2CevoIHiW3F4YjSySLYcVHpXc6oF2ovOUroIGX7iACTlsOzkdgam1QuYCvK7aYpMA75awSto0YTmeKOBKiIxUM45jU5Q4aU+p+4d7jxJaYJebaYi0oN4cLlnRY+XRtcN156H+ujcmbBtR7hgf2Wh5hRdNs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=lPxQL5hS8Otzr3LMRatyIjfn0WroogojK0f9/4XawvkSfD2PMIjEzI9dLHqVzmAVrUKIQwnukPUDbMleoqp+STX5Qa/zwndREGlGvmdyosXjlJuBI/JqByNlzrsyo19qIHFedLkFIPEfn10txbUzwb6s0qGAXoCs4+GA+Nf+FQk= Received: by 10.142.14.20 with SMTP id 20mr1345996wfn.2.1201278570422; Fri, 25 Jan 2008 08:29:30 -0800 (PST) Received: by 10.142.165.8 with HTTP; Fri, 25 Jan 2008 08:29:30 -0800 (PST) Message-ID: Date: Fri, 25 Jan 2008 10:29:30 -0600 From: "Scott Marlowe" To: "Gary Stainburn" Subject: Re: regex_replace problem -additional Cc: pgsql-sql@postgresql.org In-Reply-To: <200801251619.43305.gary.stainburn@ringways.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <200801251615.59186.gary.stainburn@ringways.co.uk> <200801251619.43305.gary.stainburn@ringways.co.uk> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/196 X-Sequence-Number: 30049 On Jan 25, 2008 10:19 AM, Gary Stainburn wrote: > 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) \df regexp* List of functions Schema | Name | Result data type | Argument data types ------------+----------------+------------------+------------------------ pg_catalog | regexp_replace | text | text, text, text pg_catalog | regexp_replace | text | text, text, text, text I think you lost a p in there.