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

Поиск
Список
Период
Сортировка
От Cristian Custodio
Тема coerce_type: no conversion function from "unknown type" to text
Дата
Msg-id 000b01c2e4a1$b2a74750$fb01a8c0@ttcristian
обсуждение исходный текст
Список pgsql-general
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



В списке pgsql-general по дате отправления:

Предыдущее
От: "shreedhar"
Дата:
Сообщение: Re: Why are queries with subselects so slow?
Следующее
От: "Carl Olivier"
Дата:
Сообщение: Re: User Backend Sessions