Postgres Pro
Downloads
Home   >   mailing lists

Re: What type of index do I need for this JOIN? - Mailing list pgsql-general

From John R Pierce
Subject Re: What type of index do I need for this JOIN?
Date
Msg-id 520B465C.4040100@hogranch.com
Whole thread Raw
In response to Re: What type of index do I need for this JOIN?  (Robert James <srobertjames@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: raghu ram
Date:
Subject: Re: Need some basic information
Next
From: Tim Kane
Date:
Subject: WHERE 'Something%' LIKE ANY (array_field)