Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 46D639FB4C4 for ; Tue, 10 Jul 2007 05:08:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 00204-06 for ; Tue, 10 Jul 2007 05:08:21 -0300 (ADT) X-Greylist: delayed 00:31:27.734967 by SQLgrey-1.7.5 Received: from relay0.fra.interoute.net (relay0.fra.interoute.net [212.23.33.89]) by postgresql.org (Postfix) with ESMTP id 584D39FB453 for ; Tue, 10 Jul 2007 05:08:24 -0300 (ADT) Received: from posta.unipex.it (unknown [89.202.198.33]) by relay0.fra.interoute.net (Postfix) with ESMTP id 458FBBBFC for ; Tue, 10 Jul 2007 07:36:50 +0000 (UTC) Received: from [192.168.1.103] (michele [192.168.1.103]) by posta.unipex.it (Postfix unipex) with ESMTP id BEBBC29DE2 for ; Tue, 10 Jul 2007 09:37:24 +0200 (CEST) Message-ID: <46933711.4030501@unipex.it> Date: Tue, 10 Jul 2007 09:36:49 +0200 From: Michele Petrazzo - Unipex srl User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1b1) Gecko/20060724 Thunderbird/2.0a1 Mnenhy/0.7.4.0 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: CIdr query qestion Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms060400080103040709030202" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/43 X-Sequence-Number: 28778 This is a cryptographically signed message in MIME format. --------------ms060400080103040709030202 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi ml! A question about cidr query. I'm tring to use the various cidr functions to exclude a A sub class, but I don't understand how use it: SELECT count(ip_addr), ip_addr from wi_log_network where ip_addr != network('10.10.0.0/16', 16) group by (ip_addr); it don't exclude the 10.10 ! Tried also the abbr or set_masklen keyword, but the same. How do it? P.s. Tried the >>, but it only include the values that I want to exclude! (And I don't found how to do the opposite!) Thanks, Michele --------------ms060400080103040709030202 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIJJzCC Au4wggJXoAMCAQICEHiManFVDKLShj2ugvsxjwowDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UE BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMT I1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA2MTIwNzExMTE1OFoX DTA3MTIwNzExMTE1OFowTDEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEpMCcG CSqGSIb3DQEJARYabWljaGVsZS5wZXRyYXp6b0B1bmlwZXguaXQwggEiMA0GCSqGSIb3DQEB AQUAA4IBDwAwggEKAoIBAQC7mtBl9IqcOhjRfry9HlVsbTSb1k9ITVtnKZknSZcnMonQoVkX Axs4hXW0lC2aonPrHEKXa6mM0DMafCAbyGofv/+Hh8oQsAIhmKSWtX+R/cjgKLt+I3AHsz3T 23RVhm4kATxuXVcRSc75aWXuJ4WfVE/gAVNT/2eSxOwygYR3A7aiZYF+tE+PRRWuu5x9LlY/ wcd/mvKgY02xvOLTi+RGl7WqxNNYhh1mAZz/0vmlTrgrwpgaTwx2m2WXq8NVq4Th3C7zvHDW SLKY/XtkEcrQo8N7VuwmIWdpMfXDQBXq4JDt/FpX+Tnf2rJJDJkenOZ0T2IzkJW3G6s17u6t 7+ufAgMBAAGjNzA1MCUGA1UdEQQeMByBGm1pY2hlbGUucGV0cmF6em9AdW5pcGV4Lml0MAwG A1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEFBQADgYEAfWEtOU2ijzYheb9ShoYGJ0kn5mSLrr65 5nPgib0TWP7HPJ7HDTZgwvwm8Vk3p6/1T7oYC2leW3ansutFkg1Vog6eSvEFMlTeG1/i2nAr 7RQKX5n4n8HSQFNQcE4jXXba0UdZYUtSn5b9hI2/bweXmN2xIxoCxGn6N8tuwhU7fWAwggLu MIICV6ADAgECAhB4jGpxVQyi0oY9roL7MY8KMA0GCSqGSIb3DQEBBQUAMGIxCzAJBgNVBAYT AlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNU aGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTAeFw0wNjEyMDcxMTExNThaFw0w NzEyMDcxMTExNThaMEwxHzAdBgNVBAMTFlRoYXd0ZSBGcmVlbWFpbCBNZW1iZXIxKTAnBgkq hkiG9w0BCQEWGm1pY2hlbGUucGV0cmF6em9AdW5pcGV4Lml0MIIBIjANBgkqhkiG9w0BAQEF AAOCAQ8AMIIBCgKCAQEAu5rQZfSKnDoY0X68vR5VbG00m9ZPSE1bZymZJ0mXJzKJ0KFZFwMb OIV1tJQtmqJz6xxCl2upjNAzGnwgG8hqH7//h4fKELACIZiklrV/kf3I4Ci7fiNwB7M909t0 VYZuJAE8bl1XEUnO+Wll7ieFn1RP4AFTU/9nksTsMoGEdwO2omWBfrRPj0UVrrucfS5WP8HH f5ryoGNNsbzi04vkRpe1qsTTWIYdZgGc/9L5pU64K8KYGk8Mdptll6vDVauE4dwu87xw1kiy mP17ZBHK0KPDe1bsJiFnaTH1w0AV6uCQ7fxaV/k539qySQyZHpzmdE9iM5CVtxurNe7ure/r nwIDAQABozcwNTAlBgNVHREEHjAcgRptaWNoZWxlLnBldHJhenpvQHVuaXBleC5pdDAMBgNV HRMBAf8EAjAAMA0GCSqGSIb3DQEBBQUAA4GBAH1hLTlNoo82IXm/UoaGBidJJ+Zki66+ueZz 4Im9E1j+xzyexw02YML8JvFZN6ev9U+6GAtpXlt2p7LrRZINVaIOnkrxBTJU3htf4tpwK+0U Cl+Z+J/B0kBTUHBOI1122tFHWWFLUp+W/YSNv28Hl5jdsSMaAsRp+jfLbsIVO31gMIIDPzCC AqigAwIBAgIBDTANBgkqhkiG9w0BAQUFADCB0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdl c3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3Vs dGluZzEoMCYGA1UECxMfQ2VydGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIGA1UE AxMbVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIENBMSswKQYJKoZIhvcNAQkBFhxwZXJzb25h bC1mcmVlbWFpbEB0aGF3dGUuY29tMB4XDTAzMDcxNzAwMDAwMFoXDTEzMDcxNjIzNTk1OVow YjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4x LDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMIGfMA0GCSqG SIb3DQEBAQUAA4GNADCBiQKBgQDEpjxVc1X7TrnKmVoeaMB1BHCd3+n/ox7svc31W/Iadr1/ DDph8r9RzgHU5VAKMNcCY1osiRVwjt3J8CuFWqo/cVbLrzwLB+fxH5E2JCoTzyvV84J3PQO+ K/67GD4Hv0CAAmTXp6a7n2XRxSpUhQ9IBH+nttE8YQRAHmQZcmC3+wIDAQABo4GUMIGRMBIG A1UdEwEB/wQIMAYBAf8CAQAwQwYDVR0fBDwwOjA4oDagNIYyaHR0cDovL2NybC50aGF3dGUu Y29tL1RoYXd0ZVBlcnNvbmFsRnJlZW1haWxDQS5jcmwwCwYDVR0PBAQDAgEGMCkGA1UdEQQi MCCkHjAcMRowGAYDVQQDExFQcml2YXRlTGFiZWwyLTEzODANBgkqhkiG9w0BAQUFAAOBgQBI jNFQg+oLLswNo2asZw9/r6y+whehQ5aUnX9MIbj4Nh+qLZ82L8D0HFAgk3A8/a3hYWLD2ToZ foSxmRsAxRoLgnSeJVCUYsfbJ3FXJY3dqZw5jowgT2Vfldr394fWxghOrvbqNOUQGls1TXfj ViF4gtwhGTXeJLHTHUb/XV9lTzGCA2QwggNgAgEBMHYwYjELMAkGA1UEBhMCWkExJTAjBgNV BAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJz b25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhB4jGpxVQyi0oY9roL7MY8KMAkGBSsOAwIaBQCg ggHDMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA3MDcxMDA3 MzY0OVowIwYJKoZIhvcNAQkEMRYEFAQoKteWbJUq0hOdcfhFquyEQjLEMFIGCSqGSIb3DQEJ DzFFMEMwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMA0GCCqGSIb3DQMCAgFAMAcGBSsO AwIHMA0GCCqGSIb3DQMCAgEoMIGFBgkrBgEEAYI3EAQxeDB2MGIxCzAJBgNVBAYTAlpBMSUw IwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUg UGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQeIxqcVUMotKGPa6C+zGPCjCBhwYLKoZI hvcNAQkQAgsxeKB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGlu ZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWlu ZyBDQQIQeIxqcVUMotKGPa6C+zGPCjANBgkqhkiG9w0BAQEFAASCAQCGzFYNWfWY6pwARVyA ZTKN14WimHCXmumzxtstRH0C/O1YpwTwHTNeXgMMyClBQSP8OP12ZTvcMC9xvMbFy9DvJWvk v/vb+Maf9LgntvpVcFK7FrrDd8n0aNFydcw6Y/W7wkICVggTBXUYEHA66avbHAIrf3MM4QmT PdtHmHYdU6r9J8eg78hGhbtPXDeLaWnByWCto3sU6QfoaPTBq8SwuV7xcT/WBxh16HC9FbPl nhIEkT+PXmTrBWViDotfRJdaIVE2ZlixKPBc3HyWQDahAncCs0Sm/nFSWvWQoUtSqdokrEx+ 3mqx6S6wbzZO4qCJURihorXCLGS/FR+U4jBvAAAAAAAA --------------ms060400080103040709030202--