Re: replace " with nothing - Mailing list pgsql-sql

From Ross J. Reedstrom
Subject Re: replace " with nothing
Date
Msg-id 20110511212533.GB4796@rice.edu
Whole thread Raw
In response to Re: replace " with nothing  (Leif Biberg Kristensen <leif@solumslekt.org>)
Responses Re: replace " with nothing
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: replace " with nothing
Next
From: Leif Biberg Kristensen
Date:
Subject: Re: replace " with nothing