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 comparison/search performance benefits > over plain text for ip addresses..
Well, benchmark it and find out. :) But it'd be hard to be slower than like or regex... -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
