Thread: String Formula to calculate the value

String Formula to calculate the value

From
ram subbu
Date:
Dear All,
    I am having a formula String
say====> (a+b*c)/2
I need to pass the dynamic value to these a,b,c
 
and i need to calculate the value.
please help me out to write a procedure to do all these stufs.

Re: String Formula to calculate the value

From
"Albe Laurenz *EXTERN*"
Date:
ram subbu wrote:
>     I am having a formula String
> say====> (a+b*c)/2
> I need to pass the dynamic value to these a,b,c
>
> and i need to calculate the value.
> please help me out to write a procedure to do all these stufs.

The easiest way I can think of is to use string replacement to
replace the letters with the numbers. You can do that in Java,
but also in a PL/pgSQL function.

Then execute "SELECT <formula after replacement>", which will give
you the result.

Yours,
Laurenz Albe

Re: String Formula to calculate the value

From
"Peter"
Date:

You could use plPerl – it is very  well suited for string manipulation. Also there is eval() function that can be used for formulas like yours.

 

From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of ram subbu
Sent: Wednesday, April 08, 2009 2:56 PM
To: Kris Jurka; pgsql-jdbc@postgresql.org; pgsql-jdbc@postgresql.org
Subject: [JDBC] String Formula to calculate the value

 

Dear All,

    I am having a formula String

say====> (a+b*c)/2

I need to pass the dynamic value to these a,b,c

 

and i need to calculate the value.

please help me out to write a procedure to do all these stufs.