Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 744711337BE4 for ; Wed, 11 May 2011 18:25:41 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 67389-10 for ; Wed, 11 May 2011 21:25:34 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from cooker.cnx.rice.edu (cooker.cnx.rice.edu [168.7.5.70]) by mail.postgresql.org (Postfix) with ESMTP id C52571337BE1 for ; Wed, 11 May 2011 18:25:33 -0300 (ADT) Received: from reedstrm by cooker.cnx.rice.edu with local (Exim 4.69) (envelope-from ) id 1QKGuU-00030e-0j for pgsql-sql@postgresql.org; Wed, 11 May 2011 16:25:34 -0500 Date: Wed, 11 May 2011 16:25:34 -0500 From: "Ross J. Reedstrom" To: pgsql-sql@postgresql.org Subject: Re: replace " with nothing Message-ID: <20110511212533.GB4796@rice.edu> References: <1305145780.1954.4.camel@tony1.localdomain> <201105112311.08016.leif@solumslekt.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <201105112311.08016.leif@solumslekt.org> User-Agent: Mutt/1.5.18 (2008-05-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201105/80 X-Sequence-Number: 35364 On Wed, May 11, 2011 at 11:11:07PM +0200, Leif Biberg Kristensen wrote: > > although it's a little above me why you would want to select firstname in the > first place when you proceed to replace it with nothing. Nah, he's replacing double-quote-character " with nothing. An attempt to protect against little Bobby Tables, I assume. (see: http://xkcd.com/327/ aka SQL injection attacks, but not as fun) Ross -- Ross Reedstrom, Ph.D. reedstrm@rice.edu Systems Engineer & Admin, Research Scientist phone: 713-348-6166 Connexions http://cnx.org fax: 713-348-3665 Rice University MS-375, Houston, TX 77005 GPG Key fingerprint = F023 82C8 9B0E 2CC6 0D8E F888 D3AE 810E 88F0 BEDE