Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4FE7D9FB502 for ; Tue, 15 May 2007 07:17:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 39520-09 for ; Tue, 15 May 2007 07:17:14 -0300 (ADT) X-Greylist: delayed 00:32:34.360919 by SQLgrey-1.7.5 Received: from spoetnik.xs4all.nl (spoetnik.xs4all.nl [82.95.228.65]) by postgresql.org (Postfix) with ESMTP id 8E34C9FB4F7 for ; Tue, 15 May 2007 07:17:14 -0300 (ADT) Received: by spoetnik.xs4all.nl (Postfix, from userid 1000) id A5E261CC68; Tue, 15 May 2007 11:44:38 +0200 (CEST) Date: Tue, 15 May 2007 11:44:38 +0200 From: Reinoud van Leeuwen To: pgsql-sql@postgresql.org Subject: Re: workday function Message-ID: <20070515094438.GT72343@spoetnik.xs4all.nl> Mail-Followup-To: pgsql-sql@postgresql.org References: <200705150951.34928.gary.stainburn@ringways.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200705150951.34928.gary.stainburn@ringways.co.uk> X-message-flag: Warning! The sender of this mail thinks you should use a more secure email client. User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/127 X-Sequence-Number: 28407 On Tue, May 15, 2007 at 09:51:34AM +0100, Gary Stainburn wrote: > Hi folks > > I need to be able to add and subtract workdays, something like > > select CURRENT_DATE - '3 work days'::interval; Would that take holidays into account? (and wich ones?) -- __________________________________________________ "Nothing is as subjective as reality" Reinoud van Leeuwen reinoud.v@n.leeuwen.net http://www.xs4all.nl/~reinoud __________________________________________________