Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6DFAD475FDD; Thu, 9 Jan 2003 18:03:22 -0500 (EST) Received: from ece.rice.edu (ece.rice.edu [128.42.4.34]) by postgresql.org (Postfix) with ESMTP id 04011475F37; Thu, 9 Jan 2003 18:03:22 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by ece.rice.edu (Postfix) with SMTP id 4C53168A99; Thu, 9 Jan 2003 17:03:24 -0600 (CST) Received: from localhost (localhost [127.0.0.1]) by ece.rice.edu (Postfix) with ESMTP id DFD3A68A98; Thu, 9 Jan 2003 17:03:23 -0600 (CST) Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by ece.rice.edu (Postfix) with ESMTP id B6E9E68A96; Thu, 9 Jan 2003 17:03:22 -0600 (CST) Received: from reedstrm by wallace.ece.rice.edu with local (Exim 3.36 #1 (Debian)) id 18Wlhq-0008HE-00; Thu, 09 Jan 2003 17:03:22 -0600 Date: Thu, 9 Jan 2003 17:03:22 -0600 From: "Ross J. Reedstrom" To: "Rajesh Kumar Mallah." Cc: "Randy D. McCracken" , pgsql-sql@postgresql.org, pgsql-novice@postgresql.org Subject: Re: Search and Replace Message-ID: <20030109230322.GC30740@wallace.ece.rice.edu> Mail-Followup-To: "Ross J. Reedstrom" , "Rajesh Kumar Mallah." , "Randy D. McCracken" , pgsql-sql@postgresql.org, pgsql-novice@postgresql.org References: <200301091100.32667.mallah@trade-india.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200301091100.32667.mallah@trade-india.com> User-Agent: Mutt/1.4i X-Virus-Scanned: by AMaViS snapshot-20020300 X-DCC--Metrics: ece.rice.edu 1067; Body=1 Fuz1=1 Fuz2=1 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/140 X-Sequence-Number: 11005 On Thu, Jan 09, 2003 at 11:00:32AM +0530, Rajesh Kumar Mallah. wrote: > > any anyone explain whats wrong with the replace based solution to this problem > which i posted earlier? > > did i misunderstood anything? Probably just overkill - I'm sure it would work, but, based on how the question was asked, I guessed that the original questioner was looking for a quick, onetime fix sort of thing, and wasn't real comfortable with SQL, let alone adding contrib extension products to the installation. Ross