Numeric values shown as [53 48 48 46 48 48] in html table

The data is stored as “numeric(8,2)” and shows correctly as numeric values in a sql query using PGAdmin.

Fetching the same query in Go the numeric values destroys and gets into [53 48 48 46 48 48] unless I cast the numeric values as “text”. I am using sqlx.

list := get(query)
tpl.ExecuteTemplate(w, "hrlist.html", list)


Allt text displays correct.

How do I translate numeric values in Go?

It looks like the data is being returned as []byte whereas it is actually a string

You should be able to cast it into string and it will display properly

How do I do this using Go? In SQL I have to cast each and every of hundreds field. It must be a smarter way from within Go. Or?

What type is list in your example above? Assuming is is a slice you could iterate it creating a new list.

[map[hr_code:PM hr_date:2020-08-22 hr_id:34 hr_job:20-0001 hr_ppu:[49 48 48 48 46 48 48]]

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.