Darren Duncan wrote:
Try "like" by default, such as "where site_id like 'GW-22 %'". I added the space between the 22 and the wildcard % so that the field containing just 'GW-22' isn't also matched.
Sorry, I should have said "where site_id like 'GW-22%' and site_id != 'GW-22'" (no explicit space) as a better way to exclude 'GW-22' from the results. -- Darren Duncan
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
