Re: [GENERAL] Casting help

[Peter Eisentraut]

Mitch Vincent writes:

> if I try to cast minority to varchar (or anything else for that matter) I
> get
>
> ERROR:  Cannot cast type 'bool' to 'varchar'

Try:  CASE WHEN minority THEN 'value of true' ELSE 'value if false' END

-- 
Peter Eisentraut      [EMAIL PROTECTED]       http://yi.org/peter-e/