Hi Stephen,
> SELECT MIN(tstamp) FROM det;
> This used a sequence scan even if I do a SET ENABLE_SEQSCAN to off.
> Shouldn't this also use an index?
[...]
Have a look at the thread I started under "max() not using index". I think
you can do the same trick to work around the min() problem if it's
logical. That'd be:
SELECT tmstamp FROM det ORDER BY tmstamp ASC LIMIT 1;
Kind regards
... Ralph ...