Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> writes:
> Would another possible condition for considering
> Cartesian joins be be:
> * Consider Cartesian joins when a unique constraint can prove
> that at most one row will be pulled from one of the tables
> that would be part of this join?
What for? That would still lead us to consider large numbers of totally
useless joins.
regards, tom lane