Good catch. But why are you using a hash index for this?
Just experimenting - I was trying to determine whether a hash index would give better performance - the values are always unique except when they're 0 and < > relations are never needed. That particular query would have been needed only once for maintainance work.
Regards, Marinos
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly