From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: zhangh3@aetna.com
Subject: BUG #16835: btree index does not work for where clause using 'foo%'
Date: Fri, 22 Jan 2021 15:56:52 +0000
Message-ID: <16835-419ddd12f1e74ee5@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 16835
Logged by: Hongyan (Heather) Zhang
Email address: zhangh3@aetna.com
PostgreSQL version: 11.9
Operating system: aurora postgres 11
Description:
https://www.postgresql.org/docs/11/indexes-types.html, according to this
page, btree index is supposed to work for where clause col like 'foo%', but
does not work for me. we are on aurora postgres 11, I also tested on
postgres 11, it does not work either.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, zhangh3@aetna.com
Subject: Re: BUG #16835: btree index does not work for where clause using 'foo%'
In-Reply-To: <16835-419ddd12f1e74ee5@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox