Re: [GENERAL] Problem with index when using function

Thanks if you started to look into this, but nevermind. I figured it out. Turns out I only needed to mark the function as STABLE: http://www.postgresql.org/docs/8.0/static/xfunc-volatility.html "A STABLE function cannot modify the database and is guaranteed to return the same results given t

[GENERAL] Problem with index when using function

All, I have a weird situation where my index IS used when I use a query that hard-codes a value but it does NOT use the index when the value is returned from a PGSQL function: == DOES NOT WORK