Tom Lane escribió: > My own thought is that from_collapse_limit has more justification, > since it basically acts to stop a subquery from being flattened when > that would make the parent query too complex, and that seems like a > more understandable and justifiable behavior than treating JOIN > syntax specially.
Isn't that what we use OFFSET 0 for? That one has also the nice property that you can actually specify which subquery you want to prevent from being flattened. Personally I have never seen a case where the collapse_limits were useful tools. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers