Sailesh Krishnamurthy <[EMAIL PROTECTED]> writes: > This is probably a crazy idea, but is it possible to organize the data > in a page of a hash bucket as a binary tree ?
Only if you want to require a hash opclass to supply ordering operators, which sort of defeats the purpose I think. Hash is only supposed to need equality not ordering. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match