Andreas,
> PS: in the example the subselect join clause event_id=events.event_id is
> missing
Sorry. I was cutting-and-pasting to reduce the complexity of the query. The
full query is actually posted on -PERFORMANCE, as is a workaround to the
"exists selectivity problem".
--
Josh Berkus
Aglio Database Solutions
San Francisco