Обсуждение: coerce_type: no conversion function from "unknown type" to text

Поиск
Список
Период
Сортировка

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

От
"Cristian Custodio"
Дата:
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