Re: Casting int to bool with join...

On Fri, 2 Apr 2004 18:21:34 -0500, Randall Skelton
<skelton@brutus.uwaterloo.ca> wrote:
>UPDATE app_id_800 SET cal_byte_w_err = (CASE WHEN
>cal_byte_w_err.value=1 THEN 't'::boolean ELSE 'f'::boolean END)

or simply

    UPDATE app_id_800
       SET cal_byte_w_err = (cal_byte_w_err.value=1)

Servus
 Manfred