Re: MV Keys

From: mAsterdam <mAsterdam_at_vrijdag.org>
Date: Fri, 03 Mar 2006 18:11:27 +0100
Message-ID: <4408783f$0$11076$e4fe514c_at_news.xs4all.nl>


Marshall Spight wrote:
> Jon Heggland wrote:
>
> The relational operators don't handle lists very well.
>
> myList.removeAt(3)
>
> vs.
>
> BEGIN
> delete from MyList where Index = 3;
> update MyList set Index = Index - 1 where Index > 3;
> COMMIT
Aside (the example surely illustrates your point) could this removeAt operation possibly be useful in a concurrent environment?

You'ld never know which item you are going to scratch - somebody else could have just done myList.removeAt(2). Received on Fri Mar 03 2006 - 18:11:27 CET

Original text of this message