Request a Demo
Home   >   mailing lists

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

From Anoop G
Subject Re: how to perform minus (-) operation in a dynamic query
Date
Msg-id 1a027d210807142117y78a4d7b5if7f4b5987d0f9cea@mail.gmail.com
Whole thread Raw
In response to Re: how to perform minus (-) operation in a dynamic query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view
Hai all,

 Thanks to all , I got the answer,  actualy I am write the function in openoffice.org and paste it to a .sql file that is the reason for the error.

thanks
Anoop









On Mon, Jul 14, 2008 at 7:32 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Anoop G" <anoopmadavoor@gmail.com> writes:
> ERROR:  syntax error at or near "\226" at character 18
> QUERY:  SELECT mf,sf,(mf \226 mf * comm /100) \226 (sf \226 sf * comm/100) as
> flt_claim
> CONTEXT:  PL/pgSQL function "test_perc" line 7 at for over execute statement
> LINE 1: SELECT mf,sf,(mf \226 mf * comm /100) \226 (sf \226 sf * comm/100) as...

I'm not sure what character \226 is, but it's not a minus sign ...

                       regards, tom lane

pgsql-sql by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: Rollback in Postgres
Next
From: Ivan Sergio Borgonovo
Date:
Subject: COPY equivalent for updates