Postgres Pro
Downloads
Home   >   mailing lists

Re: Cast boolean to text - Mailing list pgsql-general

From Shoaib Mir
Subject Re: Cast boolean to text
Date
Msg-id bf54be870612070144g1d9d6a2ct6b4ee7c9ec4eeeba@mail.gmail.com
Whole thread Raw
In response to Cast boolean to text  ("Willy-Bas Loos" <willybas@gmail.com>)
List pgsql-general
Tree view
You can create a custome cast for this purpose that can convert bool to text...
 
Regards,
Shoaib

 
On 12/7/06, Willy-Bas Loos <willybas@gmail.com> wrote:
Hi,

I've noticed that postgresql  8.1.0 can cast a boolean to text, but version 8.1.5 CAN'T.
Is this a bug or a feature?

as proof, try to run this query:
select 't'::bool::text

On version 8.1.5 one will recieve the error message "can't convert boolean to text".

pgsql-general by date:

Previous
From: Henrik Zagerholm
Date:
Subject: pg_dump/pg_Restore 8.1.5 db -> 8.2 tsearch2 problem
Next
From: "Markus Wollny"
Date:
Subject: Asynchronous replication of a PostgreSQL DB to a MySQL target