Yandex Cloud
Documentation
PresentationContact UsTry it for free
© 2026 Direct Cursus Technology L.L.C.
Yandex DataLens
  • DataLens Gallery
  • Audit Trails events

[Yandex DataLens] ROUND with precision parameter is not supported for double precision data type in PostgreSQL

Written by
Yandex Cloud
Updated at December 1, 2025
View in Markdown

ERR.DS_API.DB.INVALID_FUNCTION.PG_DOUBLE_PRECISION_ROUND

The ROUND function with the precision parameter is not supported for the double precision type of PostgreSQL data source.

DataLens recognizes PostgreSQL's double precision and numeric types as a Fractional number. Out of these two types, the ROUND function with the precision parameter only supports numeric. To get double precision back to the database level, use another function: DB_CAST.

Here is an example:

ROUND(DB_CAST([your field]/1000000, 'numeric', 16, 8) [, precision ]), where 16 is the total number of digits in the fractional number, and 8 is its count of decimal places.

Was the article helpful?

© 2026 Direct Cursus Technology L.L.C.