Received: from icebox.venux.net (icebox.venux.net [216.120.166.10]) by hub.org (8.10.1/8.10.1) with ESMTP id e6LEo1h22468 for ; Fri, 21 Jul 2000 10:50:01 -0400 (EDT) Received: from doot (temp.venux.net [216.120.133.249]) by icebox.venux.net (Postfix) with SMTP id ADD1E26202 for ; Fri, 21 Jul 2000 10:54:13 -0400 (EDT) Message-ID: <001d01bff323$39cdb250$4100000a@doot> From: "Mitch Vincent" To: Subject: Timestamp indexes Date: Fri, 21 Jul 2000 10:52:00 -0400 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 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200007/207 A while back I as told (by Tom Lane I *think*) that timestamp (previously datetime) fields couldn't be indexed as such and that I should index them using this method : CREATE INDEX "applicants_resubmitted" on "applicants" using btree ( date ("resubmitted") "date_ops" ); Since almost all the queries that search that field search it casting the field to date, I thought that would be OK.. It was for a while (in the 6.5.X days) but it seems that 7.0.2 is treating this different. I can't get an index scan on that field no matter what I do. Any suggestions? Thanks! -Mitch