* Sriram Dandapani:
> Does the inet data type offer comparison/search performance benefits
> over plain text for ip addresses..
Queries like "host << '192.168.17.192/28'" use an available index on
the host column. In theory, you could do this with LIKE and strings,
but this gets pretty messy and
On Apr 24, 2006, at 3:45 PM, Sriram Dandapani wrote:
Hi
I have queries that use like operators and regex patterns to
determine if an ip address is internal or external (this is against
a table with say 100 million distinct ip addresses).
Does the inet data type offer comparison/searc
On Mon, Apr 24, 2006 at 03:45:14PM -0700, Sriram Dandapani wrote:
> Hi
>
> I have queries that use like operators and regex patterns to determine
> if an ip address is internal or external (this is against a table with
> say 100 million distinct ip addresses).
>
> Does the inet data type offer co
Hi
I have queries that use like operators and regex patterns to
determine if an ip address is internal or external (this is against a table
with say 100 million distinct ip addresses).
Does the inet data type offer comparison/search performance
benefits over plain text for ip addres
