Postgres Pro
Downloads
Home   >   mailing lists

Re: SOLVED - date range to set of dates expansion - Mailing list pgsql-sql

From Gary Stainburn
Subject Re: SOLVED - date range to set of dates expansion
Date
Msg-id 201201191610.15842.gary.stainburn@ringways.co.uk
Whole thread Raw
In response to Re: date range to set of dates expansion  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Gary Stainburn
Date:
Subject: Re: date range to set of dates expansion
Next
From: Adrian Klaver
Date:
Subject: Re: date range to set of dates expansion