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

Hi,

Anoop G wrote:
> vchr_query:= 'SELECT mf,sf,(mf – mf * comm /100) – (sf – sf * comm/100) 
> as flt_claim';

Simply use a real minus sign '-', and not a hyphen '–'. (Try 
copy'n'pasting from this email, if nothing else works ;-) )

Regards

Markus