Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D531A9FB989 for ; Thu, 12 Apr 2007 02:29:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 39323-05 for ; Thu, 12 Apr 2007 02:29:13 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.240]) by postgresql.org (Postfix) with ESMTP id A497F9FA326 for ; Thu, 12 Apr 2007 02:29:14 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c24so471498ana for ; Wed, 11 Apr 2007 22:29:14 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; 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; b=gLY1aKnSBI2nS76g+2uCKyvJ8V6seCBWu2JLpajriMX58opGoM4kHAJYkbjcaDPF+nuwUHi01MwW5EOWfGyEBpD3gHNC8uLbGUADh0OLM6ORTkGdaLJMM7q7A8l7vGfbClix4IsX1M3zqc+HSdKzcs+vt9t8rCT3eIKeoER7Kkk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=lHNb/ZO4SzWgUC4xPjai4ObnVppEY3W+4WN6H04swlFwr7MhuQpwL2aiNcn91ARS28dzTp16USnK9Td3xsvW5x68NZpcWhTj6DQLr0W+bWKxYKwPVaFDVLG2J0jFIuruhY1WSiNGanrUwgk5fekoMmCWhnf1peHhDMB0M08rioQ= Received: by 10.100.57.14 with SMTP id f14mr1045990ana.1176355753514; Wed, 11 Apr 2007 22:29:13 -0700 (PDT) Received: by 10.100.154.9 with HTTP; Wed, 11 Apr 2007 22:29:13 -0700 (PDT) Message-ID: Date: Thu, 12 Apr 2007 00:29:13 -0500 From: "=?ISO-8859-1?Q?Rodrigo_De_Le=F3n?=" To: "PostgreSQL SQL List" Subject: Re: Replace string Cc: "PostgreSQL Admin" In-Reply-To: <461BF649.70204@productivitymedia.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <461BF649.70204@productivitymedia.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/125 X-Sequence-Number: 28125 On 4/10/07, PostgreSQL Admin wrote: > Hi, > > I want to replace a title with dashes and also remove punctuation. > > e.g, The blue fox's fur. -> The-blue-fox-fur > > > Thanks for any input, > J SELECT translate('The blue fox''s fur.', ' .''', '-')