Re: [sqlite] cidr data type

2008-04-19 Thread Christof Meerwald
On Fri, 18 Apr 2008 15:59:14 -0600, Dennis Cote wrote: > Christof Meerwald wrote: >> Currently, I am thinking of storing start and end IP addresses as a blob in >> the database - that way I would be able to use the "between" operator in >> selects, e.g. >>

[sqlite] cidr data type

2008-04-18 Thread Christof Meerwald
Hi, does SQLite have anything similar to PostgreSQL's cidr data type (see http://www.postgresql.org/docs/8.3/interactive/datatype-net-types.html). I would be particularly interested in being able to use a "contained in" operator in selects - in PostgreSQL you are able to do: select inet