Re: unexpected join results

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: unexpected join results
Дата
Msg-id 135.1048013366@sss.pgh.pa.us
обсуждение исходный текст
Ответ на unexpected join results  (Matthew Phillips <mphillips@timing.com>)
Список pgsql-general
Matthew Phillips <mphillips@timing.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Big insert/delete memory problems
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: copying between Postgres databases