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(at)gmail(dot)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".
>