Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: cannot cast type boolean to text?
Date
Msg-id 16941.1181846325@sss.pgh.pa.us
Whole thread Raw
In response to cannot cast type boolean to text?  (Brian Hurt <bhurt@janestcapital.com>)
Responses Re: cannot cast type boolean to text?  ("Shoaib Mir" <shoaibmir@gmail.com>)
List pgsql-novice
Tree view 
Brian Hurt <bhurt@janestcapital.com> writes:
>     SELECT true :: text;
> ERROR:  cannot cast type boolean to text

> I was wondering why this is so.

Because there's no pg_cast entry for this conversion.

There will be one in 8.3, but for older releases make your own with
CREATE CAST.

            regards, tom lane

pgsql-novice by date:

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