Thread

1. Escape Quotes

   Keith Gray <keith@heart.com.au> — 2001-05-11T01:11:46Z

   When using apostrophies the PostgreSQL string seems to like 
   an escape character as follows:
   
   
   	update client set code = 'O\'SHEA' where clientid = 2;
   
   
   The ANSI-92 standard seems to suggest that this could/should 
   be handled by 
   
   <quote> ::= '
   <quote symbol> ::= <quote><quote>
   
   	update client set code = 'O''SHEA' where clientid = 2;
   
   
   Is it possible to get/configure PostgreSQL to handle <quote><quote>
   as <quote> within a dleimited string?
   
   
   Keith Gray
   
   

2. Re: Escape Quotes

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-05-11T02:34:03Z

   Keith Gray <keith@heart.com.au> writes:
   > Is it possible to get/configure PostgreSQL to handle <quote><quote>
   > as <quote> within a dleimited string?
   
   We already do.
   
   regression=# select 'O''SHEA';
    ?column?
   ----------
    O'SHEA
   (1 row)
   
   
   			regards, tom lane
   
   

3. Re: Escape Quotes

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-05-11T02:38:51Z

   Keith Gray <keith@heart.com.au> writes:
   > This may be a problem in "ipgsql" then??
   
   I guess.  What is that, anyway?
   
   > ...or is it different in update from select?
   
   Nope, a literal is a literal.
   
   			regards, tom lane
   
   

4. Re: Escape Quotes

   Keith Gray <keith@heart.com.au> — 2001-05-11T02:40:43Z

   Tom Lane wrote:
   > 
   > Keith Gray <keith@heart.com.au> writes:
   > > Is it possible to get/configure PostgreSQL to handle <quote><quote>
   > > as <quote> within a dleimited string?
   > 
   > We already do.
   > 
   > regression=# select 'O''SHEA';
   >  ?column?
   > ----------
   >  O'SHEA
   > (1 row)
   > 
   >                         regards, tom lane
   Sorry,
   
   This may be a problem in "ipgsql" then??
   ...or is it different in update from select?
   
   Keith
   
   

5. Re: Escape Quotes

   Keith Gray <keith@heart.com.au> — 2001-05-11T03:17:41Z

   > > > Is it possible to get/configure PostgreSQL to handle <quote><quote>
   > > > as <quote> within a delimited string?
   > >
   > > We already do.
   > >
   > 
   > This may be a problem in "ipgsql" then??
   > ...or is it different in update from select?
   
   
   The problem is in ipqsql... 
   it doesn't handle update, but does handle select.
   
   Both work fine for psql (linux).
   
   
   Keith.
   
   

6. Re: Re: Escape Quotes

   Roberto Mello <rmello@cc.usu.edu> — 2001-05-11T04:45:43Z

   On Fri, May 11, 2001 at 01:17:41PM +1000, Keith Gray wrote:
   > 
   > The problem is in ipqsql... 
   
   	What the heck is ipsql??
   
   	-Roberto
   -- 
   +----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
     Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
          http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
   In Borland you are never bored!
   
   

7. ipsql (was - Escape Quotes)

   Keith Gray <keith@heart.com.au> — 2001-05-11T05:22:07Z

   Roberto Mello wrote:
   > 
   >         What the heck is ipsql??
   > 
   >         -Roberto
   
   ipgsql
   
   A Win32 client for interactive Postgres session
   
   
   Keith