Re: [GENERAL] Query with varchar not using functional index

2008-06-26 Thread Tom Lane
"Ryan VanMiddlesworth" <[EMAIL PROTECTED]> writes: > I've got a very strange problem that I'm seeing in one of our PostgreSQL > databases (7.4.19). Specifically, I have a query that only uses the > functional index that it's supposed to use if I cast to text. Yeah, 7.4 is not very bright about re

[GENERAL] Query with varchar not using functional index

2008-06-26 Thread Ryan VanMiddlesworth
Hello, I've got a very strange problem that I'm seeing in one of our PostgreSQL databases (7.4.19). Specifically, I have a query that only uses the functional index that it's supposed to use if I cast to text. Here is a slimmed down version of the table definition: Column |