Casting int to bool with join...

Поиск
Список
Период
Сортировка
Искать
От
Randall Skelton
Тема
Casting int to bool with join...
Дата
Msg-id
3BF5CD7C-84FA-11D8-BEF7-000393C92230@brutus.uwaterloo.ca
Список
Дерево обсуждения
Casting int to bool with join... Randall Skelton <skelton@brutus.uwaterloo.ca>
Re: Casting int to bool with join... Randall Skelton <skelton@brutus.uwaterloo.ca>
Re: Casting int to bool with join... Manfred Koizar <mkoi-pg@aon.at>
I am trying to update rows in a new table and re-cast to boolean at the 
same time.  I am absolutely certain that the integers are 0 or 1.  Is 
there a one line way to do this?

UPDATE app_id_800 SET cal_byte_w_err = cal_byte_w_err.value::boolean
FROM cal_byte_w_err
WHERE app_id_800.timestamp BETWEEN '2004-01-01 00:00:00' AND 
'2004-01-01 00:00:05'
AND app_id_800.timestamp = cal_byte_w_err.timestamp;

Many thanks... I've spent way too long trying to figure this out :(

Cheers,
Randall

В списке pgsql-general по дате отправления
От: Manfred Koizar
Дата:
От: muteki
Дата:
Сообщение: relfilenode on 7.2.3
FAQ