inet data type and select

Поиск
Список
Период
Сортировка
От bse@games.global.co.za
Тема inet data type and select
Дата
Msg-id Pine.LNX.4.05.9906041540530.31305-100000@games.global.co.za
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Cary O'Brien"
Дата:
Сообщение: Re: [HACKERS] Priorities for 6.6 (Large Objects)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Backend sent 0x45 type while idle