Re: String Formula to calculate the value - Mailing list pgsql-jdbc

From Albe Laurenz *EXTERN*
Subject Re: String Formula to calculate the value
Date
Msg-id D960CB61B694CF459DCFB4B0128514C202FF6554@exadv11.host.magwien.gv.at
Whole thread Raw
In response to String Formula to calculate the value  (ram subbu <ramgv80@yahoo.com>)
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Array passing
Next
From: "Peter"
Date:
Subject: Re: String Formula to calculate the value