Matthew Phillips <mphillips(at)timing(dot)com> writes:
> 2 | 2003-03-18 10:10:07 | 2003-02-18 10:09:06 | 2003-02-18 10:10:03
> This output is expected and perfectly ok... the problem is when I add
> one more condition to the query. 'and m.second <= l.end_time'. This
> would match rows in which second falls in between begin_time and end
> time, something all the above rows do.
Uh ... March comes after February, last I checked.
regards, tom lane