Tom Lane wrote:
> 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