Re: Q: inet operators for IPv4 encapsulated in IPv6

2023-09-06 Thread Albrecht Dreß
Am 06.09.23 19:41 schrieb(en) Erik Wienhold: The docs don't spell it out, but inet operators and functions expect values of the same inet family. Comparing IPv4 and IPv6 always returns false, e.g. [1]. The only hint in the docs that may imply this is [2]: "When sorting inet or cidr dat

Re: Q: inet operators for IPv4 encapsulated in IPv6

2023-09-06 Thread Erik Wienhold
On 06/09/2023 16:51 CEST Albrecht Dreß wrote: > I have a question regarding the use of inet operators in environments with > mixed IPv4 and IPv6 notations. > > Consider the example from sect. 9.12. “Network Address Functions and > Operators” > in the docs which returns properly > > > postgres=#

Q: inet operators for IPv4 encapsulated in IPv6

2023-09-06 Thread Albrecht Dreß
I have a question regarding the use of inet operators in environments with mixed IPv4 and IPv6 notations. Consider the example from sect. 9.12. “Network Address Functions and Operators” in the docs which returns properly postgres=# select '192.168.1.5'::inet << '192.168.1/24'::inet; ?column?