On Thu, Mar 18, 2004 at 03:39:12PM -0500, Tom Lane wrote:
> Michael Adler <[EMAIL PROTECTED]> writes:
> > In porting an application from v7.2 and v7.3, I noticed that a join on a varchar
> > column and a text column was ignoring indices that were helpful in v7.2. When I
> > explicitly cast the te
Michael Adler <[EMAIL PROTECTED]> writes:
> On Thu, Mar 18, 2004 at 03:39:12PM -0500, Tom Lane wrote:
>> A desultory test didn't show any difference between 7.2.4 and 7.3.6
>> in this respect, however. Perhaps you forgot to ANALYZE yet in the
>> new database?
> I have a test with sample data and
In porting an application from v7.2 and v7.3, I noticed that a join on a varchar
column and a text column was ignoring indices that were helpful in v7.2. When I
explicitly cast the text to a varchar (or set ENABLE_SEQSCAN TO false) the index is
scanned and it works as efficiently as in v7.2.
