"Jim C. Nasby" <decibel@decibel.org> writes:
> (SELECT b.bucket_id AS rrs_bucket_id, s.*
> FROM rrs.bucket b
> JOIN page_log.log s
> ON (
> b.prev_end_time < log_time
> AND b.end_time >= log_time )
> WHERE b.rrs_id = '1'
> AND b.end_time <= '2005-01-21 20:23:00+00'
> AND b.end_time > '1970-01-01 00:00:00+00'
> ) a
> Basically, it seems that it doesn't understand that each row in log will
> match up with at most one row in bucket. There is a unique index on
> bucket(rrs_id, end_time), so it should be able to tell this.
Why should it be able to tell that?
regards, tom lane
