Received: from miaou.thefreecat.org ([213.11.8.225]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAJ7X8m17044 for ; Mon, 19 Nov 2001 02:33:12 -0500 (EST) (envelope-from cat@thefreecat.org) Received: from bast (bast.thefreecat.local [192.168.0.2]) by miaou.thefreecat.org (Postfix) with ESMTP id 07EBB554004; Mon, 19 Nov 2001 08:32:56 +0100 (CET) Date: Mon, 19 Nov 2001 08:32:54 +0100 From: Jean-Christophe Boggio X-Mailer: The Bat! (v1.53d) Personal Reply-To: Jean-Christophe Boggio X-Priority: 3 (Normal) Message-ID: <1243398546.20011119083254@thefreecat.org> To: Tom Lane , pgsql-sql@postgresql.org Subject: Re: Optimization with dates In-Reply-To: <868508534.20011114130251@thefreecat.org> References: <72319017913.20011114005656@thefreecat.org> <4596.1005705832@sss.pgh.pa.us> <868508534.20011114130251@thefreecat.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200111/264 X-Sequence-Number: 5646 So, no one can help ? Should I stop defining indexes for date fields ? ie: should DATE types be considered broken with no short time solution and be replaced with strings ? -- Jean-Christophe Boggio cat@thefreecat.org -o) Independant Consultant and Developer /\\ Delphi, Linux, Perl, PostgreSQL, Debian _\_V