On lau, 2008-07-12 at 14:45 +0530, Anoop G wrote: > Hai Kretschmer , > Thanks for your reply, it help to solve my problem. I have few for > doubts regarding dynamic query ... > vchr_query:= 'SELECT mf,sf,(mf – mf * comm /100) – (sf – sf * > comm/100) as flt_claim'; the '–' characters here probably are not what you think. try with '-'
... > but when I am traing to run this function I got the following error > > ERROR: syntax error at or near "–" at character 18 > QUERY: SELECT mf,sf,(mf – mf * comm /100) – (sf – sf * comm/100) as > flt_claim gnari -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
