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@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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

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