Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.3 planner ignore index with text_pattern_ops for eq - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 8.3 planner ignore index with text_pattern_ops for eq
Date
Msg-id 14060.1218035009@sss.pgh.pa.us
Whole thread Raw
In response to 8.3 planner ignore index with text_pattern_ops for eq  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List pgsql-hackers
Tree view 
"Pavel Stehule" <pavel.stehule@gmail.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

pgsql-hackers by date:

Previous
From: "Pavel Stehule"
Date:
Subject: 8.3 planner ignore index with text_pattern_ops for eq
Next
From: "Hiroshi Saito"
Date:
Subject: Re: unable to build libpq on Win 2003 (32 bit)