coerce_type: no conversion function from "unknown type" to text - Mailing list pgsql-general

From Cristian Custodio
Subject coerce_type: no conversion function from "unknown type" to text
Date
Msg-id 000b01c2e4a1$b2a74750$fb01a8c0@ttcristian
Whole thread Raw
List 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 by date:

Previous
From: "shreedhar"
Date:
Subject: Re: Why are queries with subselects so slow?
Next
From: "Carl Olivier"
Date:
Subject: Re: User Backend Sessions