Merlin,
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.
It's esoteric enough that I don't know what you're talking about. Can you give us an example?
--Josh ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
