Thread: indexing date and timestamp fields...

Does it make any sence to index a date field? I am guessing that PostgreSQL
has already optimized these fields???

Thanks in advance,

Alan

"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