Scott,
You can use the regex I posted to get rid of the data easily, then go back to the substr one for a check constraint after that.
regex is non-standard. How to implement this in standard SQL ? Andrus. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
