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