Well... well. uhhh well.
My feeble mind has managed to work out another very, very simple solutionto this:
select price, price / 2::float as halfprice from item_money;
All of my fretting and worrying, and the answer was that simple.
daggonnit,
Bob