I'm getting an error ERROR: invalid input syntax for integer: "0.384"
.
Upon inspection, i found this is for a field that is unwrapped from a json field.
Now, i would like to set the type of this field as float
or decimal
, but i don't see any such option anywhere.
How do i resolve this?
Note: every time i try to resync the database schema or re-scan the field values, the operation results in the same error as mentioned above.