Bill Moseley wrote: > > Is this the "blanket increment/decrement" that's referring to? > > sqlite> update track set pos = pos - 1 where cd = 1 and pos > 2; >
No need for where conds and the like. The most minimal test case is to create a table with 1 column, with a unique constraint, and put in the numbers 1..5. Then try: UPDATE tab SET col = col + 1; and UPDATE tab SET col = col - 1; On sqlite (at least) on of these fails. Not sure for other databases, never had the time to test. _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
