Re: unexpected join results - Mailing list pgsql-general

From Tom Lane
Subject Re: unexpected join results
Date
Msg-id 135.1048013366@sss.pgh.pa.us
Whole thread Raw
In response to unexpected join results  (Matthew Phillips <mphillips@timing.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Big insert/delete memory problems
Next
From: "scott.marlowe"
Date:
Subject: Re: copying between Postgres databases