From: | elwood(at)agouros(dot)de (Konstantinos Agouros) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | INET contains question |
Date: | 2002-04-05 21:52:10 |
Message-ID: | elwood.1018043381@news.agouros.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I have a table that contains a two columns of type inet. One is an address one
is a network. Due to an error in an application there are some rows where the
address is not contained in the network. So I did a:
select sourceip,whoisnet,dnsnet from attacks where not (sourceip << whoisnet);
which is more or less right but in the cases where the whoisnet is not a class
a/b/c-network I also get a match which is not correct. Is this supposed to be
so or a bug?
I am using 7.1 on Linux to do this.
Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood(at)agouros(dot)de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not survive the forming of the cosmos." B'Elana Torres
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Adler | 2002-04-05 22:00:01 | |
Previous Message | Andreas Scherbaum | 2002-04-05 21:48:30 | setuid functions |