Re: inet <<= and indexes

Yes, we have a TODO list. I will add this:

* Allow INET subnet tests with non-constants

---------------------------------------------------------------------------

The Doctor What wrote:
> * Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) [020806 22:47]:
> > Edwin Grubbs <egrubbs(at)rackspace(dot)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(at)gerf(dot)org KF6VNC
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026