From: Gary Stainburn <gary.stainburn@ringways.co.uk>
Organization: Ringways Garages Ltd
To: pgsql-sql@postgresql.org
Subject: Solved - best way: diary functions.
Date: Wed, 4 Apr 2007 14:27:08 +0100
User-Agent: KMail/1.9.5
References: <200704031325.50542.gary.stainburn@ringways.co.uk>
In-Reply-To: <200704031325.50542.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: <200704041427.09056.gary.stainburn@ringways.co.uk>

My solution that works is:

select date_range as rdate, 
  case 
      when rsgsid is not null then 2
      when aid is not null then 1
      else 0
  end as status
  from date_range('2007-04-01','2007-04-30')
  left join availability a on a.asid = 1 and (date_range,date_range) overlaps 
(a.asdate,a.afdate)
  left join roster_staff r on r.rsdate = date_range;

Can anyone see any problems or improvements to this?
-- 
Gary Stainburn
 
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000