On Thu, Dec 24, 2009 at 4:47 PM, Andrus <kobruleht2@hot.ee> wrote:
> 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 ?
I take it you need a way to scrub your data in various databases, not
just pgsql? I'm not sure there is a simple SQL standard way. It's
likely that this one time job might require various non-standard ways
of scrubbing your data this one time. You're gonna have to figure
out how to make databases other than pgsql happy without me, the only
one I'm even a little familiar with is Oracle, and my oracle-fu is
rather rusty after a three year or so lay off from it.
