Re: how to perform minus (-) operation in a dynamic query

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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "Anoop G" <anoopmadavoor(at)gmail(dot)com> 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
>