Re: indexing date and timestamp fields...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alan T(dot) Miller" <amiller(at)hollywood101(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: indexing date and timestamp fields...
Date: 2004-01-18 03:28:35
Message-ID: 1642.1074396515@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Alan T. Miller" <amiller(at)hollywood101(dot)com> writes:
> Does it make any sence to index a date field?

Certainly.

> I am guessing that PostgreSQL has already optimized these fields???

What is your notion of "optimized"? Date is not any more magic than any
other datatype in Postgres.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2004-01-19 01:25:18 Re: How to turn flat file to SQL
Previous Message Alan T. Miller 2004-01-18 00:38:05 indexing date and timestamp fields...