Re: Casting int to bool with join...

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Randall Skelton <skelton(at)brutus(dot)uwaterloo(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Casting int to bool with join...
Date: 2004-04-03 00:54:31
Message-ID: 0o2s60pvejhvbkiln7s5dntj36tld051g1@email.aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 2 Apr 2004 18:21:34 -0500, Randall Skelton
<skelton(at)brutus(dot)uwaterloo(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-04-03 00:57:47 Re: [GENERAL] Large DB
Previous Message Manfred Koizar 2004-04-03 00:40:39 Re: [GENERAL] Large DB