On Fri, Jan 22, 2010 at 2:02 PM, Greg Stark <gsstark(at)mit(dot)edu> wrote:
> The question arises why Postgres can't automatically detect that this
> query is equivalent.
Hm, actually rereading your query it's not technically equivalent.
Since you weren't grouping on contact.id or contact_type.code if you
happened to have multiple contacts that had the same name and address
and multiple codes which had the same name then your query would
consolidate them into one result record. You might know that will
never happen but the database can't prove that's true so it would
never be able to do this transform.
--
greg