On Sat, Jul 28, 2007 at 10:36:16PM +0000, Ragnar wrote:
> 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'
IMO, much better would be:
WHERE data_encerramento >= '2006-12-01' AND data_encerramento <
This means you don't have to worry about last day of the month or
timestamp precision. In fact, since the field is actually a timestamp,
the between posted above won't work correctly.
Decibel!, aka Jim Nasby decibel(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
In response to
pgsql-performance by date
|Next:||From: Bruno Rodrigues Siqueira||Date: 2007-07-29 16:44:23|
|Subject: RES: RES: select on 1milion register = 6s|
|Previous:||From: Jay Kang||Date: 2007-07-29 14:22:30|
|Subject: Questions on Tags table schema|