Re: how to perform minus (-) operation in a dynamic query

From: Markus Wanner <markus(at)bluegap(dot)ch>
To: Anoop G <anoopmadavoor(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: how to perform minus (-) operation in a dynamic query
Date: 2008-07-14 11:43:28
Message-ID: 487B3BE0.9090605@bluegap.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2008-07-14 14:02:33 Re: how to perform minus (-) operation in a dynamic query
Previous Message A. Kretschmer 2008-07-14 06:13:57 Re: how to perform minus (-) operation in a dynamic query