Thread

1. % escape

   Jie Liang <jliang@ipinc.com> — 2000-08-15T19:02:34Z

   Hi,there,
   
   Is anybody know  how I can escape % or ' (my column contains % or '  )
   in my text field.
   
   select mystring from textbook where mystring like .....
   
   --
   Jie LIANG
   
   Internet Products Inc.
   
   10350 Science Center Drive
   Suite 100, San Diego, CA 92121
   Office:(858)320-4873
   
   jliang@ipinc.com
   www.ipinc.com
   
   
   
   
   

2. Re: % escape

   Jesus Aneiros <aneiros@jagua.cfg.sld.cu> — 2000-08-15T19:37:17Z

   To escape % use \\% as in '50\\%', to escape ' use '' as in 'o''conell',
   retrieves o'conell
   
   Regards.
   
   --
   Jesus Aneiros Sosa
   mailto:aneiros@jagua.cfg.sld.cu
   http://jagua.cfg.sld.cu/~aneiros
   
   On Tue, 15 Aug 2000, Jie Liang wrote:
   
   > Hi,there,
   > 
   > Is anybody know  how I can escape % or ' (my column contains % or '  )
   > in my text field.
   > 
   > select mystring from textbook where mystring like .....
   > 
   > --
   > Jie LIANG
   > 
   > Internet Products Inc.
   > 
   > 10350 Science Center Drive
   > Suite 100, San Diego, CA 92121
   > Office:(858)320-4873
   > 
   > jliang@ipinc.com
   > www.ipinc.com
   > 
   > 
   > 
   
   
   

3. serial field dump bug

   Yury Don <yura@vpcit.ru> — 2000-08-16T06:49:51Z

   Dear Madam or Sir,
   
   Looks like I've found a bug in PostgreSQL, bug report is in attachment.
   
   
   -- 
   Sincerely yours,
   Yury

4. Re: serial field dump bug

   Tom Lane <tgl@sss.pgh.pa.us> — 2000-08-19T03:27:09Z

   Yury Don <yura@vpcit.ru> writes:
   > After creating table with serial field if table or this field name has
   > an uppercase letters, sequence creating for this field doesn't double
   > quoted.
   
   This is already fixed for 7.1.  Thanks for the report...
   
   			regards, tom lane