Hai all, Thanks to all , I got the answer, actualy I am write the function in openoffice.org and paste it to a .sql file that is the reason for the error.
thanks Anoop On Mon, Jul 14, 2008 at 7:32 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Anoop G" <[EMAIL PROTECTED]> writes: > > ERROR: syntax error at or near "\226" at character 18 > > QUERY: SELECT mf,sf,(mf \226 mf * comm /100) \226 (sf \226 sf * > comm/100) as > > flt_claim > > CONTEXT: PL/pgSQL function "test_perc" line 7 at for over execute > statement > > LINE 1: SELECT mf,sf,(mf \226 mf * comm /100) \226 (sf \226 sf * > comm/100) as... > > I'm not sure what character \226 is, but it's not a minus sign ... > > regards, tom lane >