On 5/14/07, Nemo Terry <[EMAIL PROTECTED]> wrote:
Look at this problem:
when
execute 'insert into lse_installations values(' || ''''||obj_id||'''' || ',' ||
''''||div||'''' || ',' || ''''||sub||'''' || ',' || ''''||obj_type||'''' || ','
|| ''''||obj_name||'''' || ',' || ''''||pstcd||'''' || ',' || ''''||rdcd||''''
|| ',' || ''''||blkno||'''' || ',' || ''''||vldunt||'''' || ','|| cenlat || ','
|| cenlon || ')';
because obj_name from another table has value like this:S'pore High Polymer.
Following error raises:
ERROR: syntax error at or near "pore"
SQL state: 42601
Context: PL/pgSQL function "lse_installations" line 64 at execute statement
So how to process the single inverted comma in char variable?It makes me so
desperate.
Why are you EXECUTEing the INSERT command? It's directly supported in
plpgsql, since it is a superset of SQL. That is, you can do:
INSERT INTO lse_installations
VALUES (obj_id, div, sub, obj_type, obj_name, pstcd, rdcd, blkno, vldunt
, cenlat, cenlon);
Good luck.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
