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(at)postgresql(dot)org [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of ram subbu
Sent: Wednesday, April 08, 2009 2:56 PM
To: Kris Jurka; pgsql-jdbc(at)postgresql(dot)org; pgsql-jdbc(at)postgresql(dot)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.