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.