Thom Brown <thom(at)linux(dot)com> writes:
> This doesn't look like a bug, but rather an enhancement request.
Yeah, not one of these are bugs. Some of them might be missed
optimization opportunities. But you'd need to show that the extra
planning cost of detecting such cases is worthwhile, ie there's
a reasonably large fraction of real-world queries that would
benefit materially.
regards, tom lane