postgres round by variable decimal place

Question

I have a rounding length value by contract. I would like to round my data table by this value however I cannot find how to input it dynamically (ie changing 2 in the example below by 5). Is it possible?

Table trading.data18 structure idcontract integer close double

Table contracts structure idcontract integer rounding double

My static query so far

select ROUND(CAST(close AS numeric),2) from trading.data18 limit 10;

Can you share your table structures pls.

Stefanov.sm
– Stefanov.sm

2022-12-21 11:09:01 +00:00
Commented Dec 21, 2022 at 11:09 — Stefanov.sm
– Stefanov.sm, Commented Dec 21, 2022 at 11:09
@Stefanov.sm I have added the request

matel
– matel

2022-12-21 11:24:25 +00:00
Commented Dec 21, 2022 at 11:24 — matel
– matel, Commented Dec 21, 2022 at 11:24

Stefanov.sm · Accepted Answer · 2022-12-21 11:37:19Z

1

You can use contracts.rounding as a second argument of round.

select round(d.close, c.rounding::integer)::numeric
from trading.data18 as d
join contracts as c using(idcontract);

using(idcontract) is a shorthand for on c.idcontract = d.idcontract

answered Dec 21, 2022 at 11:37

Stefanov.sm

13.3k2 gold badges25 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgres round by variable decimal place

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related