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