Re: [sqlite] IPv{4,6} addressing extension

On 27 Feb 2012, at 10:51, Alexey Pechnikov wrote: > You can use integer representation of IPv4 addresses as your "internal > format" for sorting and sumilar tasks: Thanks, Alexey. I know that, but it's an approach which fragments the problem which I very much want to

Re: [sqlite] IPv{4,6} addressing extension

You can use integer representation of IPv4 addresses as your "internal format" for sorting and sumilar tasks: SELECT IP2INT('0.0.0.0'); ==>0 SELECT IP2INT('192.168.1.1'); ==>3232235777 SELECT IP2INT('255.255.255.255'); ==>4294967295 The integer