Re: Problem in dynamic query execution in plpgsql

From: Ragnar <gnari(at)hive(dot)is>
To: Anoop G <anoopmadavoor(at)gmail(dot)com>
Cc: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Problem in dynamic query execution in plpgsql
Date: 2008-07-12 10:06:50
Message-ID: 1215857210.15516.3.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Martín Marqués 2008-07-12 13:15:29 CHAR to INT
Previous Message Simon Riggs 2008-07-12 09:20:37 Re: Rollback in Postgres