Nis Jørgensen skrev:
> Lonni J Friedman skrev:
>> Greetings,
>> I've got an interesting problem. I have a table with a column full of
>> timestamps. I need a means of returning only the rows which have a
>> timestamp that falls after the last 16:00 and before the next 16:00
>> (on the clock), regardless of date.
> SELECT *
> FROM footable0
> WHERE (date_created - interval '16 hours')::date = (now() - interval '16
> hours')::date;
>
> Tested.
Unfortunately, the performance is horrible - it is using a seqscan. Use
Michaels suggestion instead (at least if you have a significant amount
of data).
Nis
