Re: [PERFORM] Timestamp-based indexing

Mon, 26 Jul 2004 11:43:04 -0700

THAT WAS IT!!

Thank you very much.
Is there a way to change the type of "CURRENT_TIMESTAMP" to "timestamp without time zone" so that casting isn't needed?


BTW, isn't this a bug?

-- Harmon


Stephan Szabo wrote: 
On Mon, 26 Jul 2004, Harmon S. Nine wrote:

  
However, we can't get the planner to do an timestamp-based index scan.

Anyone know what to do?
    

I'd wonder if the type conversion is causing you problems.
CURRENT_TIMESTAMP - INTERVAL '10 minutes' is a timestamp with time zone
while the column is timestamp without time zone.  Casting
CURRENT_TIMESTAMP to timestamp without time zone seemed to make it able to
choose an index scan on 7.4.

Reply via email to