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.