Thread: RE: [HACKERS] inet type & select

RE: [HACKERS] inet type & select

From
"Jackson, DeJuan"
Date:
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@games.global.co.za [SMTP:bse@games.global.co.za]
> Sent:    Friday, June 04, 1999 7:21 PM
> To:    pgsql-hackers@postgreSQL.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---
>    -----!!!-------
>