Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsgate.cistron.nl!transit4.news.xs4all.nl!post.news.xs4all.nl!not-for-mail Date: Fri, 03 Mar 2006 18:11:27 +0100 From: mAsterdam Organization: Pakhuis User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.theory Subject: Re: MV Keys References: <1140915349.609443.285650@e56g2000cwe.googlegroups.com> <1140916287.800990.284570@t39g2000cwt.googlegroups.com> <1140928045.223226.301140@i40g2000cwc.googlegroups.com> <440185c0$0$11076$e4fe514c@news.xs4all.nl> <1140963712.820976.72300@u72g2000cwu.googlegroups.com> <4401cd8b$0$11062$e4fe514c@news.xs4all.nl> <1140981916.897576.34490@u72g2000cwu.googlegroups.com> <1141000908.277461.101140@t39g2000cwt.googlegroups.com> <1141180942.125742.288830@j33g2000cwa.googlegroups.com> <1141239957.788010.239620@j33g2000cwa.googlegroups.com> <1141260473.796686.131530@u72g2000cwu.googlegroups.com> <1141324828.479189.199000@i40g2000cwc.googlegroups.com> <1141399209.093211.14150@z34g2000cwc.googlegroups.com> In-Reply-To: <1141399209.093211.14150@z34g2000cwc.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Lines: 21 Message-ID: <4408783f$0$11076$e4fe514c@news.xs4all.nl> NNTP-Posting-Host: 82.92.225.151 X-Trace: 1141405759 news.xs4all.nl 11076 [::ffff:82.92.225.151]:32429 X-Complaints-To: abuse@xs4all.nl Xref: dp-news.maxwell.syr.edu comp.databases.theory:37197 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).