Postgres Pro
Downloads
Home   >   mailing lists

Cast boolean to text - Mailing list pgsql-general

From Willy-Bas Loos
Subject Cast boolean to text
Date
Msg-id 1dd6057e0612070108j62cc1bb8j9a579e7de1791719@mail.gmail.com
Whole thread Raw
Responses Re: Cast boolean to text  ("Shoaib Mir" <shoaibmir@gmail.com>)
Re: Cast boolean to text  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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: Alban Hertroys
Date:
Subject: Re: From Clause
Next
From: Alban Hertroys
Date:
Subject: Re: dynamic SQL - variable substitution in plpgsql