""Greg Sabino Mullane"" <[EMAIL PROTECTED]>
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> | UPDATE
> | orderby SET orderby = orderby +10
> | WHERE groupid = 1;
> | -> FAILS because of UNIQUE INDEX
>
> One workaround is to do it in two steps, assuming that
> orderby is > 0 for all rows
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
| UPDATE
| orderby SET orderby = orderby +10
| WHERE groupid = 1;
| -> FAILS because of UNIQUE INDEX
One workaround is to do it in two steps, assuming that
orderby is > 0 for all rows you are changing:
BEGIN;
UPDATE mytable SET orderby = -orderby W
