Postgres Pro
Downloads
Home   >   mailing lists

Re: Casting int to bool with join... - Mailing list pgsql-general

From Manfred Koizar
Subject Re: Casting int to bool with join...
Date
Msg-id 0o2s60pvejhvbkiln7s5dntj36tld051g1@email.aon.at
Whole thread Raw
In response to Re: Casting int to bool with join...  (Randall Skelton <skelton@brutus.uwaterloo.ca>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Randall Skelton
Date:
Subject: Re: Casting int to bool with join...
Next
From: "Jeffrey R. Greco"
Date:
Subject: namespace dilemma