Re: 8.3 planner ignore index with text_pattern_ops for eq

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
Cc: "Pg Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 8.3 planner ignore index with text_pattern_ops for eq
Date: 2008-08-06 15:03:29
Message-ID: 14060.1218035009@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> writes:
> there is some different behave between 8.3 and 8.1, 8.4 versions. 8.3
> can't share index for like and equ op.

No, and neither could any other pre-8.4 version.
http://archives.postgresql.org/pgsql-committers/2008-05/msg00346.php

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Saito 2008-08-06 15:30:40 Re: unable to build libpq on Win 2003 (32 bit)
Previous Message Pavel Stehule 2008-08-06 14:55:16 8.3 planner ignore index with text_pattern_ops for eq