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
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=#
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?