pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Fernando Hevia <fhevia@ip-tel.com.ar>
Cc: pgsql-sql@postgresql.org
Subject: Re: First day of month, last day of month
Date: Thu, 24 Apr 2008 09:16:01 -0600
Message-ID: <dcc563d10804240816v58322af0jaeb6d3a0b58967f2@mail.gmail.com> (raw)
In-Reply-To: <023b01c8a61d$5855cea0$8f01010a@iptel.com.ar>
References: <f16f7ea00804240559y6694c19fx102e57ea4455b07d@mail.gmail.com>
	<481085D1.2010807@sympatico.ca>
	<48108813.6070401@sympatico.ca>
	<481095FB.7090600@denterprises.org>
	<f16f7ea00804240743la32b08cm6ced0d9ced56948a@mail.gmail.com>
	<dcc563d10804240755w612ec586l6bf8b0f4a805d49f@mail.gmail.com>
	<023b01c8a61d$5855cea0$8f01010a@iptel.com.ar>

On Thu, Apr 24, 2008 at 9:10 AM, Fernando Hevia <fhevia@ip-tel.com.ar> wrote:
>  > De: pgsql-sql-owner@postgresql.org
>  > [mailto:pgsql-sql-owner@postgresql.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.



view thread (21+ messages)  latest in thread

Message-ID: <dcc563d10804240816v58322af0jaeb6d3a0b58967f2@mail.gmail.com>
Permalink:  ../dcc563d10804240816v58322af0jaeb6d3a0b58967f2@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10804240816v58322af0jaeb6d3a0b58967f2@mail.gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: scott.marlowe@gmail.com, fhevia@ip-tel.com.ar
  Subject: Re: First day of month, last day of month
  In-Reply-To: <dcc563d10804240816v58322af0jaeb6d3a0b58967f2@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox