Just to add something about classification, paddlefish ARE sturgeons. They are highly specialized and unusual, but they are sturgeons.
I have once seen one in an public indoor pond, but after some weeks it wasn´t there anymore. I have also read a report of a fish breeder which had young paddlefish and young salmons, and the paddlefish decimated the salmons dramatically by eating them (I have to add that the salmons were not that much smaller than the paddlefish). They will also learn to eat floating pellets, so it is probably much easier to feed them than many people think. But still this is surely no aquarium fish. Possibly a candidate for big ponds, but not for tanks, except for very small specimens.