inet data type and select - Mailing list pgsql-hackers

From bse@games.global.co.za
Subject inet data type and select
Date
Msg-id Pine.LNX.4.05.9906041540530.31305-100000@games.global.co.za
Whole thread Raw
List 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



pgsql-hackers by date:

Previous
From: "Cary O'Brien"
Date:
Subject: Re: [HACKERS] Priorities for 6.6 (Large Objects)
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Backend sent 0x45 type while idle