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

Roberts, Jon wrote:
> A case statement will work just fine:
>
> select case when sub.col1 = 'y' then true else false end as
> col1_boolean, sub.col1 from (select cast('y' as varchar) as col1) sub

Be aware of the danger here.  What happens if col1 is NULL?