Date Index - Mailing list pgsql-sql

From Ryan Hansen
Subject Date Index
Date
Msg-id 001e01c93ad0$ffcbe190$ff63a4b0$@hansen@brightbuilders.com
Whole thread Raw
Responses Re: Date Index  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-sql
<div class="Section1"><p class="MsoNormal">Hey all,<p class="MsoNormal"> <p class="MsoNormal">I’m apparently too lazy
tofigure this out on my own so maybe one of you can just make it easy on me. <span
style="font-family:Wingdings">J</span> <p class="MsoNormal"> <p class="MsoNormal">I want to index a timestamp field but
Ionly want the index to include the yyyy-mm-dd portion of the date, not the time.  I figure this would be where the
“expression”portion of the CREATE INDEX syntax would come in, but I’m not sure I understand what the syntax would be
forthis.<p class="MsoNormal"> <p class="MsoNormal">Any suggestions?<p class="MsoNormal"> <p
class="MsoNormal">Thanks!</div>

pgsql-sql by date:

Previous
From: "Helio Campos Mello de Andrade"
Date:
Subject: Re: Subqueries
Next
From: "Scott Marlowe"
Date:
Subject: Re: Date Index