On Wed, Sep 14, 2011 at 9:42 AM, Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
