Richard Jones <[EMAIL PROTECTED]> writes:
>   select countryid from iptocountry where network >> '1.2.3.4';

> Is there a suitable index that I can put on the network field to fix
> this?

Not at the moment :-(.  I think it might be possible to write a GIST
opclass that could handle this, but there's not one there today.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to