I replaced my Jayco original king mattress with a Sleep Number bed a couple of months ago. I should have done it the first day (I have been full time since August 2010). The bed is fantastic and is even lighter than the original mattress (which I just finished burning). It holds air without any noticeable leaking down when it doesn't have power to it, but even if it did, the pump is almost silent and only takes a couple of minutes to air it up from completely flat. Less than a minute to go from 50% to 100%.
Sleep Number sells RV versions, including the short Queen, in their retail stores. The RV King with Radius corners is only available through Camping World.
Would I do it again? In a minute without any hesitation.