The following bug has been logged on the website: Bug reference: 7575 Logged by: Mr-4 Email address: mr.dash.f...@googlemail.com PostgreSQL version: 9.1.4 Operating system: Linux (kernel 3.5) Description:
1. select '10.1.1.0/24'::inet between '10.1.1.0'::inet and '10.1.1.255'::inet gives me FALSE. 2. select '10.1.0.0/24'::inet between '10.1.0.0'::inet and '10.1.255.255'::inet also produces FALSE. To my understanding, 10.1.1.0/24 covers the range 10.1.1.0-10.1.1.255, so the first statement above should produce TRUE, not FALSE. It is similar to "select 1 between 1 and 1" which, quite rightly, produces TRUE. Same goes for the second statement above: 10.1.0.0/24 covers the range 10.1.0.0-10.1.0.255, which falls fully within the 10.1.0.0-10.1.255.255 (10.1.0.0/16) range. Am I missing something obvious? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs