Re: [PERFORM] Guesses on what this NestLoop is for?

2003-10-28 Thread Manfred Koizar
On Mon, 27 Oct 2003 15:32:41 -0800, Josh Berkus [EMAIL PROTECTED] wrote: FROM event_types, events LEFT OUTER JOIN ... WHERE events.status = 1 or events.status = 11 and events.event_date '2003-10-27' and events.etype_id = event_types.etype_id and ( ... );

[PERFORM] Guesses on what this NestLoop is for?

2003-10-27 Thread Josh Berkus
Folks, I'm getting this plan on 7.2.4: -- explain select events.event_id, events.event_name, type_name, COALESCE(cases.case_name || '(' || cases.docket || ')', trial_groups.tgroup_name) as event_case,