Received: from mblox.com (unknown [213.155.153.59]) by postgresql.org (Postfix) with ESMTP id 51F14475D68 for ; Tue, 23 Apr 2002 10:05:14 -0400 (EDT) Received: from salamander (salamander.mblox.com [::ffff:192.168.2.102]) (AUTH: LOGIN ian.cass) by aerosmith with esmtp; Tue, 23 Apr 2002 14:05:18 +0000 Message-ID: <001b01c1eacf$aeaae610$6602a8c0@salamander> From: "Ian Cass" To: "Tom Lane" Cc: pgsql-sql@postgresql.org References: <005501c1eaaa$46eb2500$6602a8c0@salamander> <11066.1019570198@sss.pgh.pa.us> Subject: Re: Date indexing Date: Tue, 23 Apr 2002 15:03:44 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200204/276 X-Sequence-Number: 7540 > Don't use text, use a date. Thanks, I'll try that. > One might also wonder why you're not just storing the column as type > date rather than timestamp in the first place, if you're certain you > do not need finer resolution. Because in other instances, I do need the extra resolution. This is a high level overview report I'm trying to write. -- Ian Cass