Re: Odd number of rows expected

"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