| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: First day of month, last day of month |
| Date: | 2008-04-24 15:16:01 |
| Message-ID: | dcc563d10804240816v58322af0jaeb6d3a0b58967f2@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thu, Apr 24, 2008 at 9:10 AM, Fernando Hevia <fhevia(at)ip-tel(dot)com(dot)ar> wrote:
> > De: pgsql-sql-owner(at)postgresql(dot)org
> > [mailto:pgsql-sql-owner(at)postgresql(dot)org] 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | TJ O'Donnell | 2008-04-24 15:43:17 | Re: How I can check a substring is a valid number in postgresql ? |
| Previous Message | Fernando Hevia | 2008-04-24 15:10:34 | Re: First day of month, last day of month |