Re: index question

On Sun, May 1, 2016 at 6:31 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Sunday, May 1, 2016, Melvin Davidson <melvin6925(at)gmail(dot)com> wrote:
>
>>
>> Your index is based on split_part function
>> but the WHERE clause is specific to full_path, so the planner cannot find
>> a valid index
>>
>>
>
>
> David J.
>

>This sentence is even less useful than the questions that you asked...
Your comments are antagonistic at best, but perhaps you should take a
course in english.

To clarify, the index is based on a function called "split_part(....)
The WHERE clause is only referencing the full_part column, so the planner
cannot associate the index with the full_part column.

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.