SunWuKung wrote:
However I have a problem with this cast. I don't know how to handle
brackets in the equation, since
SELECT 35/124 ::numeric
--0.28
while
SELECT (35/124) ::numeric
-- 0
The brackets aren't your problem, your numbers aren't as accurate as the
result you require. An eval()
Hi :
How about creating a view that converts integer into
numeric?
create view as
select ::numeric as ,
select ::numeric as
...
and then query the view instead. This way your formula
doesn't need to use cast anymore.
ludwig lim
--- SunWuKung <[EMAIL PROTECTED]> wrote:
> I have equations s
I have equations stored in strings and I would need to evaluate them in
pgsql - get the result.
Maybe there is an eval() function but I couldn't find it.
The only way I found was to use something like this:
calcstring_arg:= 'SELECT ' || calcstring_arg || ' ::numeric AS
outparam';
FOR tmp IN EXECU