inet data type and select
Started by Nonameover 26 years ago1 messages
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* groovy if I could do the following: (select sum(size) from
iptraff where scrip = "209.100.30.0/24")
That would tell me the total 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