Re: Identifying Reason for Column Name Returned by SELECT

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.