Re: [SQL] ' escape
От | jwieck@debis.com (Jan Wieck) |
---|---|
Тема | Re: [SQL] ' escape |
Дата | |
Msg-id | m0znJQL-000EBPC@orion.SAPserv.Hamburg.dsh.de обсуждение исходный текст |
Ответ на | Re: [SQL] ' escape (Bruce Momjian <maillist@candle.pha.pa.us>) |
Ответы |
Re: [SQL] ' escape
|
Список | pgsql-sql |
> > 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) #
В списке pgsql-sql по дате отправления: