Re: Fwd: Re: Dynamic update of a date field

On 02/16/12 2:34 PM, David Salisbury wrote:
>
> Would it not be advantageous to replicate information in the above
> form if you wanted to, say, get all records in the month of May, and
> therefore create an index on the month field?  I would think that
> would be more efficient than creating a functional index on a timestamp.
> And if you're not too picky, that would give an index that couldn't
> be done on a timestamptz field, as that's mutable.

an index on a timestamp will work just fine on date_trunc('month',
timestampfield)



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast