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!