Re: pgsql DATE

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