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