inet type & select

From: bse(at)games(dot)global(dot)co(dot)za
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: inet type & select
Date: 1999-06-05 00:20:50
Message-ID: Pine.LNX.4.05.9906050219250.7859-100000@games.global.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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---
-----!!!-------

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 1999-06-05 01:32:13 Re: [HACKERS] Priorities for 6.6
Previous Message Don Baccus 1999-06-05 00:18:07 Re: [HACKERS] Priorities for 6.6