Tobias Brox <tobias@nordicbet.com> writes:
>> time (datetime) > '2005-06-21 10:36:22+02'
>> or
>> time (timestamp) > 'some timestamp pointing to yesterday'
> If I have understood it correctly, the planner will recognize the timestamp
> and compare it with the statistics in the first example but not in the
> second, and thus it will be more likely to use index scan on the first one
> and seqscan on the second.
That statement is true for releases before 8.0. Kjell has not at any
point told us what PG version he is running, unless I missed it...
regards, tom lane