Date Index

From: "Ryan Hansen" <ryan(dot)hansen(at)brightbuilders(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Date Index
Date: 2008-10-30 20:49:16
Message-ID: 001e01c93ad0$ffcbe190$ff63a4b0$@hansen@brightbuilders.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hey all,

I'm apparently too lazy to figure this out on my own so maybe one of you can
just make it easy on me. J

I want to index a timestamp field but I only 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 for this.

Any suggestions?

Thanks!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Scott Marlowe 2008-10-30 21:06:15 Re: Date Index
Previous Message Helio Campos Mello de Andrade 2008-10-30 12:52:57 Re: Subqueries