From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
---|---|
To: | bse(at)games(dot)global(dot)co(dot)za, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | RE: [HACKERS] inet type & select |
Date: | 1999-06-07 18:50:07 |
Message-ID: | D05EF808F2DFD211AE4A00105AA1B5D21F23E3@cpsmail |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
try :
select '209.100.30.2'::inet<<='209.100.30.0/24';
Hey, I know nothing about the inet type or IPv4 or v6 but I found this one
by using \do in psql.
-DEJ
> -----Original Message-----
> From: bse(at)games(dot)global(dot)co(dot)za [SMTP:bse(at)games(dot)global(dot)co(dot)za]
> Sent: Friday, June 04, 1999 7:21 PM
> To: pgsql-hackers(at)postgreSQL(dot)org
> Subject: [HACKERS] inet type & select
>
> 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---
> -----!!!-------
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kaare Rasmussen | 1999-06-07 21:03:03 | Re: [HACKERS] Priorities for 6.6 |
Previous Message | Brian E Gallew | 1999-06-07 18:39:32 | Re: [HACKERS] Priorities for 6.6 |