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.