Josh Berkus <josh@agliodbs.com> writes:
> I generally try to avoid using LIMIT, as it is a non-SQL92 extension.
Fair enough ...
> Also,
> LIMIT in subqueries might someday be disallowed as it interferes with the
> fundmentally unordered nature of subqueries.
I don't think so; we went out of our way to make it work, so we're
unlikely to discard the feature. It's true that it does prevent some
optimizations that might otherwise occur, but not using it is a
sufficient answer to that.
regards, tom lane