Sorry for using the list as a scratch-pad for my brain.
select aid, asid,
generate_series(asdate-'1970-01-01'::date,
afdate-'1970-01-01'::date)+'1970-01-01'::date as adate,
acomments
from availability;
Has done the trick.
--
Gary Stainburn
Group I.T. Manager
Ringways Garages
http://www.ringways.co.uk