Update int array based on parent

Question

I have the following int[] in my database:

'{0}'
'{0,0}'
'{0,0,0}'
'{0,0,0,0}'

This column is used to sort my tree data. Now when a parent updates it's order the children should also update. For example if the second record updates it's order to 1 it should result in the following.

'{0}'
'{0,1}'
'{0,1,0}'
'{0,1,0,0}'

So I was wondering what the query would be to update record 3 and 4. In case it's not clear what I am asking leave a comment I can add additional information.

Screenshot of my actual data:

Screenshot of my actual data

Clodoaldo Neto · Accepted Answer · 2012-10-22 16:59:07Z

2

update t
set sort[2] = 1
where sort[1:2] = array[0,0]

answered Oct 22, 2012 at 16:59

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update int array based on parent

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related