quote_literal() fails with unmatched quotes

Поиск
Список
Период
Сортировка
От James M Doherty
Тема quote_literal() fails with unmatched quotes
Дата
Msg-id !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAGKgFc6RcN0+tZU9CuUmdQ8KAAAAQAAAA7ZDi0h8KMky4aKnUj24nJAEAAAAA@jdoherty.net
обсуждение исходный текст
Ответы Re: quote_literal() fails with unmatched quotes  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: quote_literal() fails with unmatched quotes  ("James M Doherty" <jim@jdoherty.net>)
Список pgsql-sql
I have had the following problem and been unable to determine the cause !nmostlikemat := iso_date(nmostlikemat);
EXECUTE ''insert into scenario_inv (''    || ''inv_id,''    || ''record_date,''    || ''scenario_type,''    ||
''mostlikemat,''   || ''mktpr,''    || ''mktyld )''    || '' values ( ''    || quote_literal(ID)    || '',''    ||
quote_literal(nnrecord_date)   || '',''    || quote_literal(nscid)    || '',''    || quote_literal(nmostlikemat)    ||
'',''   || quote_literal(nmktpr)    || '',''    || quote_literal(nmktyld)    || '');'';
 
The following error returns from postgres 8.1
ERROR:  unterminated quoted string at or near "'2009-10-03" at character 122
QUERY:  insert into scenario_inv
(inv_id,record_date,scenario_type,mostlikemat,mktpr,mktyld ) values (
'405832','2005-06-30','1','2009-10-03
CONTEXT:  PL/pgSQL function "scenario_set" line 502 at execute statement
PL/pgSQL function "fix_invest_set_scenario" line 18 at if
LINE 1: ...mktpr,mktyld ) values ( '405832','2005-06-30','1','2009-10-0...
James M Doherty
Principal
JMD CONSULTING
411 Thunderbay Dr
Georgetown, TX 78626
A reputation is something others give you HONOR is something you give
yourself!



В списке pgsql-sql по дате отправления:

Предыдущее
От: "Luis Silva"
Дата:
Сообщение: child fk problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: quote_literal() fails with unmatched quotes