RE: [HACKERS] inet type & select
От | Jackson, DeJuan |
---|---|
Тема | RE: [HACKERS] inet type & select |
Дата | |
Msg-id | D05EF808F2DFD211AE4A00105AA1B5D21F23E3@cpsmail обсуждение исходный текст |
Список | 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@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--- > -----!!!------- >
В списке pgsql-hackers по дате отправления: