This question is old, so, probably my next answer is just relevant recently.

As of today - tested in a postgresql 15 - the function trunc does the trick:

SELECT round(cast (41.0255 as numeric),3), --> 41.026
       trunc(cast (41.0255 as numeric),3)  --> 41.025