Re: First day of month, last day of month - Mailing list pgsql-sql

From Fernando Hevia
Subject Re: First day of month, last day of month
Date
Msg-id 023b01c8a61d$5855cea0$8f01010a@iptel.com.ar
Whole thread Raw
In response to Re: First day of month, last day of month  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: First day of month, last day of month  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-sql
 

> -----Mensaje original-----
> 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?

Regards,
Fernando.



pgsql-sql by date:

Previous
From: "Bart Degryse"
Date:
Subject: Re: First day of month, last day of month
Next
From: Erik Jones
Date:
Subject: Re: First day of month, last day of month