inet type & select
Hello.
I'm busy writing an IP accounting DB using nacctd and postgres.
The data gets inserted correctly into the database and I can run the
select queries that I desire.
E.g. (select sum(size) from iptraff where srcip = "209.100.30.2") gives
me the total bytes that that particular host sent. Now it would be
*REALLY* cool if I could do the following: (select sum(size) from
iptraff where scrip = "209.100.30.0/24")
That would tell me the total outgoing traffic for that subnet.
From what I understand the relevant code resides in network.c
unfortunately I am not a C person :-( Perhaps this feature would be
included in the next snapshot/release or someone could help me with my
particular installation.
Thanks!
ChrisG
-----!!!-------
---FREE THE SOURCE---
-----!!!-------
try :
select '209.100.30.2'::inet<<='209.100.30.0/24';
Hey, I know nothing about the inet type or IPv4 or v6 but I found this one
by using \do in psql.
-DEJ
Show quoted text
-----Original Message-----
From: bse@games.global.co.za [SMTP:bse@games.global.co.za]
Sent: Friday, June 04, 1999 7:21 PM
To: pgsql-hackers@postgreSQL.org
Subject: [HACKERS] inet type & selectHello.
I'm busy writing an IP accounting DB using nacctd and postgres.
The data gets inserted correctly into the database and I can run the
select queries that I desire.E.g. (select sum(size) from iptraff where srcip = "209.100.30.2") gives
me the total bytes that that particular host sent. Now it would be
*REALLY* cool if I could do the following: (select sum(size) from
iptraff where scrip = "209.100.30.0/24")
That would tell me the total outgoing traffic for that subnet.From what I understand the relevant code resides in network.c
unfortunately I am not a C person :-( Perhaps this feature would be
included in the next snapshot/release or someone could help me with my
particular installation.Thanks!
ChrisG
-----!!!-------
---FREE THE SOURCE---
-----!!!-------
Import Notes
Resolved by subject fallback