Postgres Pro
Downloads
Home   >   mailing lists

Re: indexing date and timestamp fields... - Mailing list pgsql-novice

From Tom Lane
Subject Re: indexing date and timestamp fields...
Date
Msg-id 1642.1074396515@sss.pgh.pa.us
Whole thread Raw
In response to indexing date and timestamp fields...  ("Alan T. Miller" <amiller@hollywood101.com>)
List pgsql-novice
Tree view 
"Alan T. Miller" <amiller@hollywood101.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

pgsql-novice by date:

Previous
From: "Alan T. Miller"
Date:
Subject: indexing date and timestamp fields...
Next
From: jaguar4096@yahoo.com (Dave)
Date:
Subject: transactions in c api (libpq)?