Re: [PERFORM] Use of to_timestamp causes full scan

2003-09-02 Thread Tom Lane
"Zaremba, Don" <[EMAIL PROTECTED]> writes: > This does a full sequential scan > select id from details where begin_time > to_timestamp('03/08/25 > 18:30'); to_timestamp('foo') is not a constant, so the planner doesn't know how much of the table this is going to select. In the absence of tha

[PERFORM] Use of to_timestamp causes full scan

2003-09-02 Thread Zaremba, Don
Has anyone seen any performace problems with the use to to_timestamp? When I use it in a where clause I get a full file scan, when I don't it uses the index for the query. The begin_time column is of type timestamp. This does a full sequential scan select id from details where begin_tim