Re: A Better Way? (Multi-Left Join Lookup)

I wrote:
> "David Johnston" <polobo(at)yahoo(dot)com> writes:
>> So,
>> EXPLAIN SELECT function_call(...) -- yields a planner expectation of 1 row
>> [Whereas]
>> EXPLAIN SELECT * FROM function_call(...) -- yields a planner expectation of
>> "result_rows" which defaults to 1000

> Hm ...

>> Was this an intentional design decision to override the result_rows estimate
>> of the function if it is used in the select list?

> Not so much an intentional decision as just that nobody ever did
> anything about it.

I've now done something about that for 9.2. I'm loath to back-patch it
into any already-stable releases, though, for fear of destabilizing
plan choices that production applications might be relying on.

regards, tom lane