Diesel cars in general will provide better fuel economy than an equivalent petrol car, but since the late 2000s the majority of diesel cars have been fitted with diesel particulate filters that can become clogged when subjected to regular short journeys without longer trips that give the DPF the chance to regenerate. If you rarely make longer journeys then the DPF can become an expensive issue, so you may find that a petrol is a better option.