Re: indices usage

On Thu, Dec 20, 2001 at 10:27:06AM -0500, Tom Lane wrote:
> Dmitry Panov <dmitry(at)tsu(dot)tula(dot)ru> writes:
> > isp_leased=# explain select count(*) from traffic_stat where timestamp between timestamp('2001-12-18') and timestamp('2001-12-19');
>
> > The question is why it doesn't make use of traffic_stat_idx2?
>
> Try '2001-12-19'::timestamp, instead, or use CAST if you want to conform
> to the standard. The function syntax is not considered a constant for
> reasons I won't delve into here.

Thanks, this solved both problems.

--
Dmitry O Panov | mailto:dmitry(at)tsu(dot)tula(dot)ru
Tula State University | http://www.tsu.tula.ru/
Dept. of CS & NIT | Fidonet: Dmitry Panov, 2:5022/5.50