Re: [Q]updating multiple rows with Different values - Mailing list pgsql-general

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