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

From: "Cristian Custodio" <crstian(at)terra(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: coerce_type: no conversion function from "unknown type" to text
Date: 2003-03-07 12:04:17
Message-ID: 000b01c2e4a1$b2a74750$fb01a8c0@ttcristian
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Carl Olivier 2003-03-07 12:14:50 Re: User Backend Sessions
Previous Message shreedhar 2003-03-07 11:27:24 Re: Why are queries with subselects so slow?