return real[] array from postgres as full float values

  Kiến thức lập trình

i have a table in postgres wich has a column with real[] entries.

enter image description here

i need to export these values as a text like this:

      CASE WHEN z > 16 THEN '{"cityJson" :' ||  cityjsonfeature::TEXT || ', "metadata" : {' || '"translate:"'||'{' ||   m.translate  ||'},'|| '"scale:"'||'{' ||   m.scale  ||'}' '}' ELSE NULL END AS cityjson,

the problem here is, that i do not get the full values, but instead it looks like this:

{98.016,1.3326125e+06,6.7176775e+06}

is there any way to get the values without the e+06 but instead as a full float value? like 1332612.5?

thanks a lot for help!!

  • postgresql

LEAVE A COMMENT