Re: SOLVED - date range to set of dates expansion

From: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: SOLVED - date range to set of dates expansion
Date: 2012-01-19 16:10:15
Message-ID: 201201191610.15842.gary.stainburn@ringways.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2012-01-19 16:20:06 Re: date range to set of dates expansion
Previous Message Gary Stainburn 2012-01-19 15:59:27 Re: date range to set of dates expansion