Have you tried using the ip4r extension yet?
First time I am seeing this - well done, exactly what I needed. That
doesn't address the above bug though - the "between" functionality is
still wrong and needs to be corrected.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
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 find that the net address inclusion operators (<< and friends)
provide the semantics you're looking for.
That isn't possible in my case, because on the right side I ha
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.
