Re: String Formula to calculate the value

Поиск
Список
Период
Сортировка
От Albe Laurenz *EXTERN*
Тема Re: String Formula to calculate the value
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C202FF6554@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на String Formula to calculate the value  (ram subbu <ramgv80@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: Array passing
Следующее
От: "Peter"
Дата:
Сообщение: Re: String Formula to calculate the value