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@xxxxxxxxx> 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".
