Thanks for bringing the SQL 92 row constructor into spec for operations involving > and <. This is just fantastic. I just benchmarked ISAM style access to tables on multi-part keys and the speedup is tremendous vs. the non row-constructor approach to the problem which is tedius to write and only selective to the first part of the key. We are talking speedups proportional to the inselectivity of the ordering key. While this feature is relatively esoteric, it is powerful and belongs in every dba's bag of tricks.
I was not expecting full indexabilty on the operation but this too works properly and efficiently. Great work! IMO, most people are not aware of a properly working row constructor because it is either not implemented or improperly implemented. Once again, the team has shown that it can meet or defeat the big name databases on the feature level. Merlin ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend