Still no joy...if i forget about the variables and just try buidling a
string to execute, eg:
sql := 'INSERT INTO application (id,body) VALUES (''asdf'',''lkjh'')';
It works.
but with the variables i still get an error...
I tried putting quotes (two single quote chars) around the VALUES variables
sql := 'INSERT INTO '+ $3 +' (id,body) VALUES ('''+ $1 +''','''+ $2
+''')';
but it still will not work. "ERROR: 42883: operator does not exist:
\"unknown\" + character varying"
Pete
On 3/6/07, Jasbinder Singh Bali <jsbali(at)gmail(dot)com> wrote:
>
>
> sql := 'INSERT INTO '+ $3 +' (id,body) VALUES ('+ $1 +','+ $2 +')';
> remove the double quotes with id and body and see if it works.
> ~Jas
>
> >
> >