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

Thanks in advance,

Alan



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

"Alan T. Miller" <amiller (AT) hollywood101 (DOT) com> writes:
Certainly.

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

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly