On Wed, Sep 14, 2011 at 9:42 AM, Steve Crawford
<scrawford@pinpointresearch.com> wrote:
> I suspect you have a multi-line entry and the '+' is just indicating that
> the field continues.
>
> Try ...where site_id ~ 'GW-22'... (this may take a while if the table is
> very large).
You might be able to get an index scan if you include a few more criteria:
AND site_id BETWEEN 'GW-22' AND 'GW-23'
Also WHERE site_id '^GW-22' may use and index scan also.
--
Regards,
Richard Broersma Jr.
