On Sat, Nov 22, 2008 at 10:04:48PM -0500, V S P wrote: > 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
Something like this?
UPDATE tbl_1 SET col1 = t.col1 FROM (VALUES
(25, 3)
(26, 5)
) AS t(id, col1)
WHERE tbl_1.id = t.id;
> 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
Regards,
Gerhard
signature.asc
Description: Digital signature
