Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!newsfeed.telusplanet.net!newsfeed2.telusplanet.net!newsfeed.telus.net!nntp.abs.net!news-FFM2.ecrc.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!195.34.132.48.MISMATCH!newsfeed01.chello.at!news.chello.at.POSTED!53ab2750!not-for-mail From: "PB" Newsgroups: comp.databases.oracle.server References: <9849ae9d.0312120948.36f1c223@posting.google.com> Subject: Re: Select between range, not in... Lines: 20 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: Date: Fri, 12 Dec 2003 18:35:54 GMT NNTP-Posting-Host: 213.47.46.210 X-Complaints-To: abuse@news.chello.at X-Trace: news.chello.at 1071254154 213.47.46.210 (Fri, 12 Dec 2003 19:35:54 MET) NNTP-Posting-Date: Fri, 12 Dec 2003 19:35:54 MET Organization: Customers chello Austria Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:250005 "Turkbear" schrieb im Newsbeitrag news:ef0ktv0g0jmnn5he0ft8fdq4p8eqr37rn2@4ax.com... > pretorianboy@yahoo.com (Pret Orian) wrote: > What determines if an address is free... Adresses in use have an entry in IPs table. The idea with IP adresses may be a bit complicated as I need to downcalculate them something like: 192.168.0.1 downcalculated results in somehing like. 1*256^0 + 0*256^1 + 168*256^2 + 168*256^3 = some number and that number should be between the ipstart and ipend of subnet the adress is assigned to.