Hi,
Here is my problem :
CREATE TABLE toc_tree (
id serial primary key,
lft int,
rgt int
)
INSERT INTO toc_tree (lft, rgt) VALUES (1, 2)
My table has the following content :
id lft rgt
1 1 2
Now I want to do the following update :
UPDATE toc_tree
SET
lft = (CASE WHEN lft > 2 THEN lft + 2 ELSE lft END),
rgt = (CASE WHEN rgt >= 2 THEN rgt + 2 ELSE rgt END)
WHERE rgt >= 2
Here is what I expect :
id lft rgt
1 1 4
And here is what I get :
id lft rgt
1 3 4
Can anybody tell me if I am missing the obvious, or if there is some
"magic" here...
This is on maxdb 7.5.0.5
I will try it on sapdb 7.4.0.30 tomorrow.
Thomas.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
