inet data type and select

From: bse(at)games(dot)global(dot)co(dot)za
To: pgsql-hackers(at)postgresql(dot)org
Subject: inet data type and select
Date: 1999-06-04 13:41:36
Message-ID: Pine.LNX.4.05.9906041540530.31305-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* 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-06-04 13:48:48 Re: [HACKERS] Backend sent 0x45 type while idle
Previous Message Cary O'Brien 1999-06-04 13:38:23 Re: [HACKERS] Priorities for 6.6 (Large Objects)