> > i had this on mysql, where the ip-addresses got saved as number's > SELECT 'input' AS typf, ipv4_dst_addr as ip, SUM(bytes) AS summe > FROM record > WHERE ((ipv4_dst_addr BETWEEN 3232235520 AND 3232235775) > or (ipv4_dst_addr BETWEEN 167772160 and 167772415));
http://www.postgresql.org/docs/8.1/interactive/functions-net.html Also z.B.: "Where ipv4_dst_addr <<'172.16.2.0/24'" für Between 172.16.2.0 AND 172.16.2.255 ipv4_dst_addr <<'192.168.16.3/31' für Between 192.168.16.3 AND 192.16.16.4 usw. HTH, Gregor _______________________________________________________________________ Viren-Scan für Ihren PC! Jetzt für jeden. Sofort, online und kostenlos. Gleich testen! http://www.pc-sicherheit.web.de/freescan/?mc=022222 _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
