Re: Problem in dynamic query execution in plpgsql - Mailing list pgsql-sql

From Ragnar
Subject Re: Problem in dynamic query execution in plpgsql
Date
Msg-id 1215857210.15516.3.camel@localhost.localdomain
Whole thread Raw
In response to Re: Problem in dynamic query execution in plpgsql  ("Anoop G" <anoopmadavoor@gmail.com>)
List pgsql-sql
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





pgsql-sql by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Rollback in Postgres
Next
From: "Martín Marqués"
Date:
Subject: CHAR to INT