Edmund Bacon wrote:
> Is there a way to convert a boolean value to text and/or vice versa?
>
[cause it doesn't work as expected]
>
> It's not that difficult to write a fuction to convert boolean to text,
> but I'm wondering if there's already something that does this?
You can help y
Is there a way to convert a boolean value to text and/or vice versa?
You can
select 'true'::boolean,
which *seems* to convert a text string to boolean, but
select 'true'::text::boolean
earns the message
ERROR: cannot cast type text to boolean
You can't go the other way either
SELECT true::text
