Re: [BUGS] Bug #747: PostgreSQL doesn't use indexes right sometimes

2002-08-26 Thread Tom Lane
[EMAIL PROTECTED] writes: > Summarized: > timefield > 'now'::datetime --> NO index > timefield > 'now'::timestamp --> index is used (OK) "datetime" is an obsolete type name that will go away entirely in 7.3, so I cannot get very excited about this. But I believe the issue is that "timestamp"

[BUGS] Bug #747: PostgreSQL doesn't use indexes right sometimes

2002-08-26 Thread pgsql-bugs
John Zero ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description PostgreSQL doesn't use indexes right sometimes Long Description There's a field in our database of type 'timestamp with time zone'. We have on index on this field. When