Hello,

Good post, but not what i'm looking for.
Well, Postgresql seems to be the winner, at least for
handling network addresses.
(Don't take me wrong. I'm not saying Postgresql is better RDBMS)

Thanks.

On 5/15/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi,

js wrote:
> Hi Baron.
> Thanks for reply.
>
> If I understand correctly,
> inet_ntoa() and inet_aton() are not capable of handling CIDR notation.

Very true, I didn't quite understand the syntax you were using.  But you can 
still use
bitwise arithmetic to work around this.  Scott Noyes wrote a nice post with 
examples:
http://thenoyes.com/littlenoise/?p=49

> On 5/15/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>> Hello,
>>
>> js wrote:
>> > Hi.
>> >
>> > Today I found postgresql's neat feature, inet operators,
>> > which allows you to do
>> >
>> > inet '192.168.1/24' >> inet '192.168.1.5'
>> >
>> > http://www.postgresql.org/docs/current/static/functions-net.html
>> >
>> > Is there anyway to do this using MySQL?
>>
>> Yes.  Have a look at the inet_ntoa() and inet_aton() functions.
>>
>> Cheers
>> Baron
>>

--
Baron Schwartz
http://www.xaprb.com/


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to