Re: What type of index do I need for this JOIN?

On 8/13/2013 8:34 PM, Robert James wrote:
> I'm confused: What's the difference between
>    col LIKE  'foo%'
> and
>    col LIKE f1 || '%'
> ?
> Either way, it's anchored to the beginning of the string.

the first one can be analyzed by the planner, the latter would be much
harder to pre-figure.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast