In reply to m0unt41n:
Firstly wishing all the best.
> Good point about mattresses being comfortable.
If you can justify it, an air mattress? All I know is when my late partner was in the hospice, the air mattresses were in high demand. Everyone said they were amazingly comfortable, and particularly for those who we in the bed for extended periods. Of course theirs probably cost a lot as they also had massage built in to minimise/stop bed sores, etc. Could be worth checking out.
As for standard adjustable beds, my mother has one. As far as I see you do need mattresses that are designed for the particular bed - I.e. To cope where it bends and flexes. Most I think are therefore memory type ones. Lots of folk think they can be too warm.
Also, remember bed linen - unless you want to remake the bed several times a day - needs to be generous in size to cope with the angles that are generated on bending/moving a lot - and needs to be as "grippy" as possible otherwise you end up sliding down to the lowest point. Worse if waterproof coverings used underneath. Lots of effort from carers if they have to keep shifting you back into position, and frustrating for you (limited use when I've been in hospital but I found it annoying to be continually moving down).
Finally, I know various people who have found electric recliner chairs to be a good/better option for day time (even night for one) use if you are fit to move.