- Архив списков рассылки pgsql-bugs

UPDATE with SUBSELECT and ORDER BY
---------------------------------------------

Hi @ Postgres BUGS...

SITUATION:

I have a Table

id   groupid   orderby

1    1         10
2    1         20
3    1         30
4    1         40
5    2         10
6    2         20
10   2         30
11   2         40

and a UNIQUE INDEX on columns "groupid,orderby"

now i want to update

UPDATE
orderby SET orderby = orderby +10
WHERE groupid = 1;

-> FAILS because of UNIQUE INDEX

NOW I WANTED TO UPDATE REVERSE:

UPDATE
orderby SET orderby = orderby +10
WHERE groupid IN
( SELECT groupid
  FROM TABLE WHERE group_id = 1
  ORDER BY orderby DESC )
;

-> FAILS TOO... SEEMS LIKE THE ORDER BY "DESC" WONT BE USED ?!?


This is with Postgres Version 8.0.3


Regards,
Claus Pruefer


----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.