[Q]updating multiple rows with Different values

Поиск
Список
Период
Сортировка
Искать
От
V S P
Тема
[Q]updating multiple rows with Different values
Дата
Msg-id
1227409488.5936.1286260393@webmail.messagingengine.com
Список
Дерево обсуждения
[Q]updating multiple rows with Different values "V S P" <toreason@fastmail.fm>
Re: [Q]updating multiple rows with Different values Andreas Kretschmer <akretschmer@spamfence.net>
Re: [Q]updating multiple rows with Different values Gerhard Heift <ml-postgresql-20081012-3518@gheift.de>
Re: [Q]updating multiple rows with Different values "V S P" <toreason@fastmail.fm>
Re: [Q]updating multiple rows with Different values "Scott Marlowe" <scott.marlowe@gmail.com>
literal limits in 8.3 Sam Mason <sam@samason.me.uk>
Re: literal limits in 8.3 Tom Lane <tgl@sss.pgh.pa.us>
Re: literal limits in 8.3 Sam Mason <sam@samason.me.uk>
Re: literal limits in 8.3 Tom Lane <tgl@sss.pgh.pa.us>
Re: literal limits in 8.3 Sam Mason <sam@samason.me.uk>
Re: literal limits in 8.3 Tom Lane <tgl@sss.pgh.pa.us>
Re: literal limits in 8.3 "Greg Sabino Mullane" <greg@turnstep.com>
Re: literal limits in 8.3 Tom Lane <tgl@sss.pgh.pa.us>
Hello,
searched documentation, FAQ and mailing list archives
(mailing list archive search is volumous :-) )

but could not find an answer:

I would like to be able to update
several rows to different values at the same time

In oracle this used to be called Array update or 
'collect' update or 'bulk' update -- but those
keywords did not bring anything for Postgresql.

for example tbl_1 has two columns id and col1


update tbl_1  set
   col1=3  where id=25,
   col1=5  where id=26


I am using PHP PDO (and hoping that if there is a mechanism
within postgresql to do that PDO will support it as well).


Thank you in advance,
VSP

-- 
  V S P
  toreason@fastmail.fm

-- 
http://www.fastmail.fm - Access all of your messages and folders
                          wherever you are

В списке pgsql-general по дате отправления
От: Scott Marlowe
Дата:
От: Bruce Momjian
Дата:
FAQ