Re: [PATCH] indexability of << operator for inet/cidr - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCH] indexability of << operator for inet/cidr
Date
Msg-id 23099.992559803@sss.pgh.pa.us
Whole thread Raw
In response to [PATCH] indexability of << operator for inet/cidr  (Alex Pilosov <alex@pilosoft.com>)
Responses Re: [PATCH] indexability of << operator for inet/cidr  (Alex Pilosov <alex@pilosoft.com>)
List pgsql-hackers
Alex Pilosov <alex@pilosoft.com> writes:
> Indexpath generated for such an expression is this:
> (a > network(b)) and (a <= set_masklen(broadcast(b, 32)))

What happens to that set_masklen thing for IPv6?

If the network.c code were exporting a function that made this value,
I'd not worry; but I don't like wiring an IPv4 assumption into code far
away in the planner.  Can't we do better here?  Perhaps move the
generation of the indexscan bound values into a subroutine in network.c?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: pg_stats view added to CVS tip
Next
From: Tom Lane
Date:
Subject: Re: Update on Access 97 and = NULL