On Wed, Sep 14, 2011 at 10:04 AM, Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote: > 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? I'm confused. Do you want to UPDATE the affected records to GW-22. Or do you want to ALTER the table to add a column constraint to prevent malformed site_id's in the future? -- 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
