Re: [SQL] 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@sss.pgh.pa.us> wrote:

"Anoop G" <anoopmadavoor@gmail.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