[BUGS] BUG #7575: "between" does not work properly with inet/cidr addresses

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.

Re: [BUGS] BUG #7575: "between" does not work properly with inet/cidr addresses

mr.dash.f...@googlemail.com writes: > 1. select '10.1.1.0/24'::inet between '10.1.1.0'::inet and > '10.1.1.255'::inet gives me FALSE. > Am I missing something obvious? 10.1.1.0/24 is different from, and sorts before, 10.1.1.0/32 (which is what '10.1.1.0'::inet is an abbreviation for). You might