Re: [SQLObject] Swapping values in a unique column

2010-07-06 Thread Oleg Broytman
On Tue, Jul 06, 2010 at 08:08:40PM +, Mark wrote: > I have a unique column, and need two rows to swap their values. > Is there a way to make the 2 updates at the same time or do I Can you do that with pure SQL? > have to update one of them to an unused value in the DB then > make the sw

[SQLObject] Swapping values in a unique column

2010-07-06 Thread Mark
I have a unique column, and need two rows to swap their values. Is there a way to make the 2 updates at the same time or do I have to update one of them to an unused value in the DB then make the swap? -- This SF.net