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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
