Re: indices usage

On Thu, Dec 20, 2001 at 10:27:06AM -0500, Tom Lane wrote:
> Dmitry Panov <dmitry@tsu.tula.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@tsu.tula.ru
Tula State University  |  http://www.tsu.tula.ru/
Dept. of CS & NIT      |  Fidonet: Dmitry Panov, 2:5022/5.50