Quick Links

A question on using CIDR datatype for both ipv6 and ipv4 address

From:	Dhaval Shah <dhaval(dot)shah(dot)m(at)gmail(dot)com>
To:	pgsql-admin(at)postgresql(dot)org
Subject:	A question on using CIDR datatype for both ipv6 and ipv4 address
Date:	2011-07-28 23:29:28
Message-ID:	CAPGmB+DJqovfoDFnCaZ+2FSOVZDpYWJTbXPev4reKck2+2EhCg@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin

I need some help in understanding why this is not working:

I have created a cidr_test table with datatypes cidr, varchar and bigint.,

And populated the table with the following values:

Note that the 5th row, is an IPV4 address in IPV4 format unlike others
which are in IPV6 format.

When I run the following query:

select * from cidr_test where inet(ip_as_cidr) >= inet '::ffff:192.0.2.124/128';

The results are different from the following:

select * from cidr_test where inet(ip_as_cidr) >= inet '192.0.2.124/32';

Let me know why I am not getting similar results when the RHS is an
IPV4 in IPV6 format vs, the RHS in IPV4 format.

Thanks in advance!

	From	Date	Subject
Next Message	Tom Lane	2011-07-28 23:58:01	Re: A question on using CIDR datatype for both ipv6 and ipv4 address
Previous Message	Tom Lane	2011-07-28 20:37:10	Re: Unique operator error w/ concatenation