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-
hhs=# INSERT INTO applicants_test (SELECT app_id ,old_id ,emp_id ,inv_id
,createdate ,updatedon ,todelete ,appstatus ,apptype ,infosent ,empinitials
,firstname ,lastname ,salutation ,fontype1 ,fonnumber1 ,fonext1 ,fontype2
,fonnumber2 ,fonext2 ,fontype3 ,fonnumber3 ,fonext3 ,address1 ,address2
,ci
