Thread

RE: [HACKERS] inet type & select

Jackson, DeJuan <djackson@cpsgroup.com> — 1999-06-07T18:50:07Z

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