Re: pgsql DATE - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: pgsql DATE
Date
Msg-id Pine.LNX.4.21.0005012145540.389-100000@localhost.localdomain
Whole thread Raw
In response to Re: pgsql DATE  (Charles Tassell <ctassell@isn.net>)
List 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


pgsql-general by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: GTK or TCL/TK ... what do you prefer ? (beginner)
Next
From: Peter Eisentraut
Date:
Subject: Re: ERROR CODE