Re: inet <<= and indexes

* Tom Lane (tgl@sss.pgh.pa.us) [020806 22:47]:
> Edwin Grubbs <egrubbs@rackspace.com> writes:
> > I have a table with about 60,000 ips, and postgres will use the index to
> > find the ips in a subnet if I type in a literal cidr block
> > (e.g. address <<= '99.88.5.0'), but it will not use the index if the cidr
> > block is in a variable (e.g. address <<= block).
>
> Yup, the present implementation of that optimization depends on having
> a constant to compare to.  Sorry ...

Is there a todo list someplace, or a bug system I can put this in,
so it'll get fixed?

Ciao!

--
Tuco: (reading a letter) See you soon idi... idi
Blondie: Idiots. It's for you.
        (The Good, The Bad, and The Ugly)

The Doctor What: <fill in the blank>             http://docwhat.gerf.org/
docwhat@gerf.org                                                   KF6VNC