From: Ragnar <gnari@hive.is>
To: Bruno Rodrigues Siqueira <bruno@ravnus.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: RES: select on 1milion register = 6s
Date: Sat, 28 Jul 2007 22:36:16 +0000
Message-ID: <1185662176.5778.314.camel@localhost.localdomain> (raw)
In-Reply-To: <002001c7d153$944f3c60$e900a8c0@brunolaptop>
References: <002001c7d153$944f3c60$e900a8c0@brunolaptop>
On lau, 2007-07-28 at 17:12 -0300, Bruno Rodrigues Siqueira wrote:
> where
>
> to_char( data_encerramento ,'yyyy-mm')
> between '2006-12' and '2007-01'
assuming data_encerramento is a date column, try:
WHERE data_encerramento between '2006-12-01' and '2007-01-31'
gnari
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-performance@postgresql.org
Cc: gnari@hive.is, bruno@ravnus.com
Subject: Re: RES: select on 1milion register = 6s
In-Reply-To: <1185662176.5778.314.camel@localhost.localdomain>
* 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