On 2004-12-06, Per Jensen <[EMAIL PROTECTED]> wrote: > Why does PG not use the index on the time column in the second select, > timeofday() has been cast to a timestamp after all.
"timestamp" is "timestamp without time zone" (not the most useful type in the world). Your column is of type "timestamp with time zone" (correct). The relationship between the two is not trivial and the lack of an index scan therefore expected. Try casting to "timestamp with time zone" instead. -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
