Hello!
I did write ipv4 extension. This works with ip addresses in text and digital
forms. I did build ip ranges as text strings same as
select intpoolfrom('3232235777-3232235778');
==>3232235777
select intpoolto('3232235777-3232235778');
==>3232235778
And networks is defined same as
SELECT NETLENGTH('192.168.1.1','255.255.255.0');
SELECT NETLENGTH('192.168.1.1,'24');
SELECT NETLENGTH('192.168.1.1,24);
SELECT NETLENGTH('192.168.1.1/255.255.255.0');
SELECT NETLENGTH('192.168.1.1/24');
==>256
May be exists more correct way for complex datatype implementation? I think
it's more useful when typeof(inet('192.168.1.1/24'))=inet (where 'inet' is new
type) but now typeof('192.168.1.1/24')=text. Collation can be used but
collation is not datatype.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
