Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 0BAE72E004B for ; Thu, 24 Apr 2008 12:10:50 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 56413-04 for ; Thu, 24 Apr 2008 12:10:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pyxis.powervt.com.ar (host3.powervt.com.ar [200.43.63.66]) by developer.postgresql.org (Postfix) with ESMTP id EFFE12E003D for ; Thu, 24 Apr 2008 12:10:44 -0300 (ADT) Received: from pcfhevia ([201.216.249.98]) by pyxis.powervt.com.ar (IPGroup Mail Server) with ESMTP id 1OT48953 for ; Thu, 24 Apr 2008 12:10:42 -0300 From: "Fernando Hevia" To: References: <481085D1.2010807@sympatico.ca> <48108813.6070401@sympatico.ca> <481095FB.7090600@denterprises.org> Subject: Re: First day of month, last day of month Date: Thu, 24 Apr 2008 12:10:34 -0300 Organization: IP-TEL Message-ID: <023b01c8a61d$5855cea0$8f01010a@iptel.com.ar> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 In-Reply-To: Thread-Index: AcimG0h0t99V0cetRpu6RFhnuwax1gAATIWg X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/165 X-Sequence-Number: 30704 > -----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.