UPDATE with multiple WHERE conditions
От
Rich Shepard
Тема
UPDATE with multiple WHERE conditions
Дата
Msg-id
c9cf4869-9d6d-7165-3f9f-611446bf961@appl-ecosys.com
Список
Дерево обсуждения
UPDATE with multiple WHERE conditions Rich Shepard <rshepard@appl-ecosys.com>
Re: UPDATE with multiple WHERE conditions Muhammad Salahuddin Manzoor <salahuddin.m@bitnine.net>
Re: UPDATE with multiple WHERE conditions Rich Shepard <rshepard@appl-ecosys.com>
Re: UPDATE with multiple WHERE conditions "David G. Johnston" <david.g.johnston@gmail.com>
Re: UPDATE with multiple WHERE conditions Rich Shepard <rshepard@appl-ecosys.com>
Re: UPDATE with multiple WHERE conditions Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: UPDATE with multiple WHERE conditions Ron Johnson <ronljohnsonjr@gmail.com>
Re: UPDATE with multiple WHERE conditions Rob Sargent <robjsargent@gmail.com>
Re: UPDATE with multiple WHERE conditions Rich Shepard <rshepard@appl-ecosys.com>
Re: UPDATE with multiple WHERE conditions Rich Shepard <rshepard@appl-ecosys.com>
I have a table with 3492 rows. I want to update a boolean column from 'false' to 'true' for 295 rows based on the value of another column. Is there a way to access a file with those condition values? If not, should I create a temporary table with one column containing those values, or do I write a psql script with 295 lines, one for each row to be updated? TIA, Rich
В списке pgsql-general по дате отправления
