Hold your arm out without your pistol and rotate your arm 90 degrees as if to hold the pistol, your wrist is in a neutral position and it is possible to tension up and hold this, Yes you can force it up and force it down but the normal hold in that natural neutral position. The wrist is a clever joint using lots of bones that slide over each other so locking like the elbow is not going to happen.