Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.1/8.9.1) with SMTP id EAA23743 for ; Tue, 8 Dec 1998 04:28:32 -0500 (EST) (envelope-from wieck@sapserv.debis.de) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@postgreSQL.org id m0znJQL-000EBPC; Tue, 8 Dec 98 10:27 MET Message-Id: From: jwieck@debis.com (Jan Wieck) Subject: Re: [SQL] ' escape To: maillist@candle.pha.pa.us (Bruce Momjian) Date: Tue, 8 Dec 1998 10:27:16 +0100 (MET) Cc: jwieck@debis.com, herouth@oumail.openu.ac.il, mancinel@univaq.it, pgsql-sql@postgreSQL.org Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: <199812072259.RAA02133@candle.pha.pa.us> from "Bruce Momjian" at Dec 7, 98 05:59:48 pm X-Mailer: ELM [version 2.4 PL25] Content-Type: text > > Hmmm - bug or feature - dunno. But telling > > > > ... DEFAULT 'Something with '''' into' ... > > > > works pretty good and as I expected it, results in one single > > quoute. > > I see the problem here: > > test=> create table test33 (a int,x char(10) default 'x\'y'); > ERROR: parser: parse error at or near "y" But create table ... default 'x\'\'y'); does. Whenever something around quotes doesn't work, I first try to double them. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #======================================== jwieck@debis.com (Jan Wieck) #