Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id E2A032E38F7 for ; Wed, 12 Dec 2007 03:30:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 02790-05-3 for ; Wed, 12 Dec 2007 03:30:21 -0400 (AST) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.177]) by postgresql.org (Postfix) with ESMTP id A860B2E38D8 for ; Wed, 12 Dec 2007 03:29:48 -0400 (AST) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrelayeu0) with ESMTP (Nemesis) id 0MKwh2-1J2M2M2H9a-0002xQ; Wed, 12 Dec 2007 08:29:46 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1J2M2M-0007eg-00 for pgsql-sql@postgresql.org; Wed, 12 Dec 2007 08:29:46 +0100 Date: Wed, 12 Dec 2007 08:29:46 +0100 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: Query design assistance - getting daily totals Message-ID: <20071212072946.GC26523@a-kretschmer.de> References: <475F3AAB.2050609@reynolds.com.au> <20071212063142.GA26523@a-kretschmer.de> <475F8234.5090907@reynolds.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <475F8234.5090907@reynolds.com.au> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX1+w9WBXkUqC9Jb3Y68IO2lAW73jQEz3aollxqB Gd4IXKpx5QzaqkGBQCG59Gwc5pRg7g/3v3IWfSRXTPwSjFh7n0 ReEMNPbQXTsM3c+zZUIZG2TKWnt5UVp X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/67 X-Sequence-Number: 29759 am Wed, dem 12.12.2007, um 15:39:48 +0900 mailte Paul Lambert folgendes: > A. Kretschmer wrote: > >am Wed, dem 12.12.2007, um 10:34:35 +0900 mailte Paul Lambert folgendes: > >>year_id integer > >>month_id integer > >>working_day integer > > > >Why this broken data types? We have date and timestamp[tz]. > > > > > > It's a financial application which needs to work using a concept of > 'financial periods' which may not necessarily correspond to calendar > months and it's much easier to manage in this way than it is to merge it Ahh, thanks for the explanation. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net