Обсуждение: Re: join on a like

If you use a btree index on the column, you should be able to use it in
the like:
http://www.postgresql.org/docs/8.1/interactive/indexes-types.html.

I guess the real question is:
what is more efficient - a join on a LIKE or a PLPGSQL function that
has 2 loops, 1 for each bottom level child and one that takes the 
substring of that child one character at a time to get each parent?

It sounds like you are saying that the join will actaully use the index 
and therefore it is optimal, not just possible.

mlartz@gmail.com wrote:
> If you use a btree index on the column, you should be able to use it in
> the like:
> http://www.postgresql.org/docs/8.1/interactive/indexes-types.html.
>