BUG #15491: index on function not being used for full text searchwhen querying through a view - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15491: index on function not being used for full text searchwhen querying through a view
Date
Msg-id 15491-5bd96f27a237da50@postgresql.org
Whole thread Raw
Responses Re: BUG #15491: index on function not being used for full text searchwhen querying through a view
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15491
Logged by:          Allen Wu
Email address:      allenwu1973@yahoo.co.jp
PostgreSQL version: 11.0
Operating system:   linux
Description:

Hi

I'm trying to implement full text search with PostgreSQL,
I found when using a function create index in conjunction with querying
through a view, will cause postgres not to use the index.
Below are example for each scenario.

When only using expression index, the index is used
https://dbfiddle.uk/?rdbms=postgres_11&fiddle=16ed7a04389ebf71dc5a1fb2daa34058

When only using view, the index is also used
https://dbfiddle.uk/?rdbms=postgres_11&fiddle=e8d50181b8612421773c2da39e45c9fd

view + expression, the index is NOT used 
https://dbfiddle.uk/?rdbms=postgres_11&fiddle=19d7b923514f100f6e402b54624cc972

I've avoid using function in my app, but I think this should have worked.
Thank you


pgsql-bugs by date:

Previous
From: Amit Langote
Date:
Subject: Re: BUG #15490: The tablespace of an index defined on a partitionedtable does not apply to a newly added partition
Next
From: Etsuro Fujita
Date:
Subject: Re: BUG #15449: file_fdw using program cause exit code error whenusing LIMIT