Hi,
I am pretty sure that on pg the whole result set is
constructed before you apply limit and offset (certainly
it is when you sort).
Thanks a lot, I'll check. The main point is probably that there are no "iterative" operations (which include PLpgSQL statements, recursive queries or wildcard searches) before the application of limit & offset. However, a hash-join with the list of accessible business object containers should be OK and should discard > 80% of all entries for any user except for some senior management guys or administrators who can see all projects...
Nice playground for database afficionados, though :)
Frank