Re: cannot cast type boolean to text? - Mailing list pgsql-novice

From Shoaib Mir
Subject Re: cannot cast type boolean to text?
Date
Msg-id bf54be870706141141k58fd91f2hd01bde4addfd5516@mail.gmail.com
Whole thread Raw
In response to cannot cast type boolean to text?  (Brian Hurt <bhurt@janestcapital.com>)
List pgsql-novice
You can do this by creating a custom cast for it.

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

On 6/14/07, Brian Hurt <bhurt@janestcapital.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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: cannot cast type boolean to text?
Next
From: "Shoaib Mir"
Date:
Subject: Re: cannot cast type boolean to text?