json_extract_path_text cast to int error

Vote count:

0

I'm trying to extract an integer from a JSON blob stored in a text field in amazon redshift. My query looks (roughly) like:

select json_extract_path_text(json_column, 'integer_field')::int from data;

However, I'm getting a strange error:

ERROR: Invalid digit, Value '1', Pos 0, Type: Integer

Why is '1' an invalid digit type? What is happening here?

asked 1 min ago

DaveA

112

json_extract_path_text cast to int error