Horton

Re: pgsql DATE

Peter Eisentraut <peter_e@gmx.net>

View thread View on postgr.es
From: Peter Eisentraut <peter_e@gmx.net>
To: Charles Tassell <ctassell@isn.net>
Cc: Martijn van Oosterhout <kleptog@cupid.suninternet.com>, Andras Balogh <abalogh@grafx.ro>, pgsql-general@postgresql.org
Date: 2000-05-01T19:49:01Z
Lists: pgsql-general 
Charles Tassell writes:

> Might want to try date BETWEEN '01/4/2000' AND '01/5/2000' as well,  this 
> is probably optimized better (although I may be wrong.)

It isn't. It's immediately converted to the below, so it's actually a few
cycles slower to use it.

> >How about you write your queries like:
> >
> >date >= '01/4/2000' and date < '01/5/2000'


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden