Thread: coerce_type: no conversion function from "unknown type" to text

coerce_type: no conversion function from "unknown type" to text

From
"Cristian Custodio"
Date:
select teste||', it dont work' from (select 'Here' as test) as tab


Body, this "select" is send-me the following error message:

coerce_type: no conversion function from "unknown type" to text

If I inside a type cast then it work

select teste||', it work' from (select cast('Here' as bpchar) as test) as
tab

Does AnyBody would know say-me whether exist a way more easy (simple) to
resolve this?

Thanks,

Cristian