postgresql and mysql and network address data types

markus1982

PostgreSQL has network address data types, MySQL misses such things.

Is it anyways possible to do something like a select on the base of a ip and netmask?

Like if you've got a field ip_adress in a table and want to select all entries corresponding to let's say

ip: 1.2.4.0
netmask: 255.255.254.0

so range would be 1.2.4.0 up till 1.2.5.255

the only way i can think of right now is creating an array with each IP adress in and then using something like

select * from data where ip = "1.2.4.1" or ip = "1.2.4.2" ... "1.2.5.255"

but this surely isn't very well ...

chriskl

Hi,

Weeell - why not just use Postgres? 🙂

If you really can't use it - then I suggest investigating MySQL's support for substring matching.

eg. something like:

select * from data where substring(ip, 0, 5) = "1.2.4";

or something...

Chris

markus1982

Sorry but this isn't a solution that will work properly. Instead I decided to create one more field called ip_adress_long and use the ip2long-function of PHP.

This way I can select IP-Ranges - just like with pgSQL - although it's a faster than the select in pgSQL :-P