"Jim C. Nasby" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org