Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group