Date: Sun, 29 Jul 2007 11:35:37 -0500
From: Decibel! <decibel@decibel.org>
To: Ragnar <gnari@hive.is>
Cc: Bruno Rodrigues Siqueira <bruno@ravnus.com>,
	pgsql-performance@postgresql.org
Subject: Re: RES: select on 1milion register = 6s
Message-ID: <20070729163536.GM25704@nasby.net>
References: <002001c7d153$944f3c60$e900a8c0@brunolaptop>
	<1185662176.5778.314.camel@localhost.localdomain>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="/QKKmeG/X/bPShih"
Content-Disposition: inline
In-Reply-To: <1185662176.5778.314.camel@localhost.localdomain>
User-Agent: Mutt/1.5.13 (2006-08-11)


--/QKKmeG/X/bPShih
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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:
>=20
> > where
> >=20
> > to_char( data_encerramento ,'yyyy-mm')=20
> > between   '2006-12' and  '2007-01'
>=20
> 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 >=3D '2006-12-01' AND data_encerramento <
'2007-02-01'

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.
--=20
Decibel!, aka Jim Nasby                        decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

--/QKKmeG/X/bPShih
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.3 (FreeBSD)

iD8DBQFGrMHYdO30qud8SkgRAgMIAJ0atZCkaGT+a3zd4foO0d7x0TqGJACfc5iq
pwP9LDIvDGjzuLNWirlXLiY=
=+mjD
-----END PGP SIGNATURE-----

--/QKKmeG/X/bPShih--