Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 9F1AB43CEB9
	for <pgsql-sql@postgresql.org>; Thu, 19 Jan 2012 12:10:34 -0400 (AST)
Received: from hub.ringways.co.uk ([77.86.27.30] helo=mail.ringways.co.uk)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <gary.stainburn@ringways.co.uk>) id 1RnuZM-0002Zp-Ph
	for pgsql-sql@postgresql.org; Thu, 19 Jan 2012 16:10:34 +0000
Received: from localhost ([127.0.0.1] helo=mail.ringways.co.uk)
	by mail.ringways.co.uk with esmtp (Exim 4.69)
	(envelope-from <gary.stainburn@ringways.co.uk>) id 1RnuZ5-0004lx-8F
	for pgsql-sql@postgresql.org; Thu, 19 Jan 2012 16:10:16 +0000
Received: from eddie.ringways.co.uk ([10.1.1.115] helo=eddie.ringways.co.uk)
	by mail.ringways.co.uk with ESMTP id qGACuK6l01976;
	Thu, 19 Jan 2012 16:10:12 +0000
From: Gary Stainburn <gary.stainburn@ringways.co.uk>
Organization: Ringways Garages Ltd
To: pgsql-sql@postgresql.org
Subject: Re: SOLVED - date range to set of dates expansion
Date: Thu, 19 Jan 2012 16:10:15 +0000
User-Agent: KMail/1.9.10
References: <201201190713.34333.gary.stainburn@ringways.co.uk>
	<201201191516.16802.gary.stainburn@ringways.co.uk>
	<201201191559.27698.gary.stainburn@ringways.co.uk>
In-Reply-To: <201201191559.27698.gary.stainburn@ringways.co.uk>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <201201191610.15842.gary.stainburn@ringways.co.uk>
X-SpamTest-Envelope-From: gary.stainburn@ringways.co.uk
X-SpamTest-Info: Profiles 20401 [Mar 31 2011]
X-SpamTest-Method: none
X-SpamTest-Rate: 0
X-SpamTest-Status: Not detected
X-SpamTest-Status-Extended: not_detected
X-SpamTest-Version: SMTP-Filter Version 3.0.0 [0285], KAS30/SDK/Release
X-Anti-Virus: Kaspersky Mail Gateway, version: 5.6.28/RELEASE,
	bases: 20110331T110535 #5151353, check: 20120119 clean
X-Spam-Score: -51.6 (---------------------------------------------------)
X-Spam-Report: Spam detection software,
	running on the system "ollie.ringways.co.uk", has
	identified this incoming email as possible spam. The original message
	has been attached to this so you can view it (if it isn't spam) or
	label similar future email.  If you have any questions, see
	Gary Stainburn <gary@ringways.co.uk> for details.
	Content preview: 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; [...]
	Content analysis details:   (-51.6 points, 15.0 required)
	pts rule name              description
	---- ----------------------
	--------------------------------------------------
	-50 ALL_TRUSTED            Passed through trusted hosts only via SMTP
	-2.6 BAYES_00 BODY: Bayesian spam probability is 0 to 1%
	[score: 0.0000] 1.0 RING_SAFE              RING_SAFE
	-0.0 AWL AWL: From: address is in the auto white-list
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201201/91
X-Sequence-Number: 36262

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