Subject Re: Round values in stored procedure
Author Adam
--- In, "Fabio Gomes" <fabioxgn@...>
> Hi all,
> Is there a way to round values in a stored procedure? i have to make
> some calculations to update some tables.. and i would like to round
> the values to 2 or 4 decimals.
> How can i do it?

With a UDF

or Multiply it by 100, cast as integer, then divide it by 100.0 should
work in straight PSQL.