Re: Use of !~* to keep a varchar column UNIQUE

On 8/18/06, Daniel T. Staal <DStaal(at)usa(dot)net> wrote:
> On Fri, August 18, 2006 1:52 pm, Don Morrison said:
>
> > The above works well enough, and I can live with it, but it is not
> > comprehensive...it would be nice to use a regular expression....and do
> > something like:
>
> The other way of doing this, depending on your data integrety needs, would
> be to use a before trigger on insert, which could trim the space and
> convert to some normalized case. PL/Perl would be a good language for
> this. ;)

Thanks for the idea Dan; I can't normalize the case in this instance
unfortunately, because the term being entered may or may not contain
an acronym. Thanks for the attempt though, I really appreciate the
positive response I've received from the pgsql-novice list. :)