<div dir="ltr">Hai all,<br /><br /> Thanks to all , I got the answer, actualy I am write the function in <a
href="http://openoffice.org">openoffice.org</a>and paste it to a .sql file that is the reason for the error.<br /><br
/>thanks<br />Anoop<br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><div class="gmail_quote">On Mon, Jul 14,
2008at 7:32 PM, Tom Lane <<a href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>> wrote:<br /><blockquote
class="gmail_quote"style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
"AnoopG" <<a href="mailto:anoopmadavoor@gmail.com">anoopmadavoor@gmail.com</a>> writes:<br /> > ERROR: syntax
errorat or near "\226" at character 18<br /> > QUERY: SELECT mf,sf,(mf \226 mf * comm /100) \226 (sf \226 sf *
comm/100)as<br /><div class="Ih2E3d">> flt_claim<br /> > CONTEXT: PL/pgSQL function "test_perc" line 7 at for
overexecute statement<br /></div>> LINE 1: SELECT mf,sf,(mf \226 mf * comm /100) \226 (sf \226 sf * comm/100)
as...<br/><br /> I'm not sure what character \226 is, but it's not a minus sign ...<br /><br />
regards,tom lane<br /></blockquote></div><br /></div>
