Rounding Problem in Stored Functions

[park40]

Hi Friends

I am having trouble with a function Round.This function returns different values in different scenarios.
This is what happens when value was directly passed

Query goes as follows

* Passing Value directly

zint numeric(12,0);

zint := Round((3000.00 / 1200),0);
return zint ;
end;'

Above Func return value 2 in zint

This is what happens when value is passed through a variable.
*Passing it through Variable.

Query goes as follows

zint numeric(12,0);
zproduct numeric(12,0);
begin
zproduct:=1000;
zproduct:=(zproduct * 3)/1200;
zint := Round(zproduct);
return zint ;
end;'

Above Func return value 3 in zint

Can anyone help me to know the difference between the two query?

[rski]

Hi Friends

I am having trouble with a function Round.This function returns different values in different scenarios.
This is what happens when value was directly passed

Query goes as follows

* Passing Value directly

zint numeric(12,0);

zint := Round((3000.00 / 1200),0);
return zint ;
end;'

Above Func return value 2 in zint

This is what happens when value is passed through a variable.
*Passing it through Variable.

Query goes as follows

zint numeric(12,0);
zproduct numeric(12,0);
begin
zproduct:=1000;
zproduct:=(zproduct * 3)/1200;
zint := Round(zproduct);
return zint ;
end;'

Above Func return value 3 in zint

Can anyone help me to know the difference between the two query?

What postgres do you use? It works fine for me, the first function return 3 I've tested it.