Postgres Pro
Downloads
Home   >   mailing lists

Re: how to perform minus (-) operation in a dynamic query - Mailing list pgsql-sql

From Tom Lane
Subject Re: how to perform minus (-) operation in a dynamic query
Date
Msg-id 7564.1216044153@sss.pgh.pa.us
Whole thread Raw
In response to how to perform minus (-) operation in a dynamic query  ("Anoop G" <anoopmadavoor@gmail.com>)
Responses Re: how to perform minus (-) operation in a dynamic query  ("Anoop G" <anoopmadavoor@gmail.com>)
List pgsql-sql
Tree view 
"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

pgsql-sql by date:

Previous
From: Markus Wanner
Date:
Subject: Re: how to perform minus (-) operation in a dynamic query
Next
From: "samantha mahindrakar"
Date:
Subject: Re: Rollback in Postgres