>
> Hi,
>
> Vadim helped me with the patch for my query.
>
> But this patch still didn't help for a simple join without a where
> clause. The query plan says it uses two sequential scans, where 6.2.1
> uses two index scans.
>
> Strange stuff.
>
> Seems like more than one problem it the optimizer code ...
>
But we didn't have subselcts in 6.2.1?
--
Bruce Momjian | 830 Blythe Avenue
maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)