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