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

---------------------------(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

Reply via email to