Re: First day of month, last day of month

On Thu, Apr 24, 2008 at 9:10 AM, Fernando Hevia <fhevia@[EMAIL PROTECTED]
>
wrote:
>  > De: pgsql-sql-owner@[EMAIL PROTECTED]
>  > [mailto:pgsql-sql-owner@[EMAIL PROTECTED]
 En nombre de Scott Marlowe
>
> >
>  > Then you can just use date_trunc on the values in the
>  > database. Plus if you're using timestamp WITHOUT timezone,
>  > you can index on it.
>  >
>
>  Did not understand this. Are you saying timestamps WITH timezone are
NOT
>  indexable or you mean that you cant build a partial index on a
>  timestamp-with-time-zone returning function?

Correct, timestamptz or timestamp with timezone (timestamptz is the
shorter alias) are not indexable because functions in an index must be
immutable, and date_trunc on a timestamptz is not.

-- 
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql