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 QAA16289 for ; Mon, 7 Dec 1998 16:00:19 -0500 (EST) (envelope-from wieck@sapserv.debis.de) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@postgreSQL.org id m0zn7v0-000EBPC; Mon, 7 Dec 98 22:10 MET Message-Id: From: jwieck@debis.com (Jan Wieck) Subject: Re: [SQL] ' escape To: herouth@oumail.openu.ac.il (Herouth Maoz) Date: Mon, 7 Dec 1998 22:10:10 +0100 (MET) Cc: mancinel@univaq.it, pgsql-sql@postgreSQL.org Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: from "Herouth Maoz" at Dec 7, 98 06:04:19 pm X-Mailer: ELM [version 2.4 PL25] Content-Type: text > > CREATE TABLE Test (name varchar(128) default 'Something with '' into'); > > > > Fails. I've tried also other alternatives : > > default "Something with ' into" > > default "Something with '' into" > > default 'Something with \' into' > > default 'Something with \27 into' > > default 'Something with \0x27 into' > > > > Everything fails. > > Interesting bug. > > As a workaround, if you really need that default value, define a simple SQL > function which returns it: Hmmm - bug or feature - dunno. But telling ... DEFAULT 'Something with '''' into' ... works pretty good and as I expected it, results in one single quoute. 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) #