With the help of some friends, I was able to find the solution. Try converting your field "text" like this: field_type_text::varchar(400)
Your query would then look like this:
select blocked_status::varchar(400) from table
I know your problem is from 2018, but since I didn't find an answer to the problem in the post, I decided to post the solution that worked for me here.
Certifications & Credly badges:
Rodrigo has no Certifications & Credly badges yet.
Hi @Joost Platenburg and @Don Martin
I had the same problem this week.
With the help of some friends, I was able to find the solution. Try converting your field "text" like this: field_type_text::varchar(400)
Your query would then look like this:
select blocked_status::varchar(400) from table
I know your problem is from 2018, but since I didn't find an answer to the problem in the post, I decided to post the solution that worked for me here.