Re: cannot cast type boolean to text?

You can do this by creating a custom cast for it.

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 6/14/07, Brian Hurt <bhurt(at)janestcapital(dot)com> wrote:
>
> I'm not sure if this is the right
> So when I do:
> SELECT true :: text;
> in psql, I get back:
>
> ERROR: cannot cast type boolean to text
>
> I was wondering why this is so. Unfortunately, the place where I hit
> the problem was in a function that takes arguments of type ANYELEMENT
> and wants to convert them to text. Which doesn't make it impossible to
> work around this, just more annoying.
>
> This is Postgres 8.1.4.
>
> Would this be something worthwhile to post to Hackers?
>
> Brian
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>