On Wed, 14 Sep 2011, Steve Crawford wrote:
I suspect you have a multi-line entry and the '+' is just indicating that the field continues.
Steve, et al.: It's not multi-line, but malformed.
Try ...where site_id ~ 'GW-22'... (this may take a while if the table is very large).
This found the appropriate rows. Now, my question is DDL-related: What is the appropriate syntax to change 'GW-22 +' to GW-22? Can I use 'like' or '~' in an ALTER TABLE RENAME <column> ... statement? Thanks guys, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
