Re: Use of !~* to keep a varchar column UNIQUE case-insensitive - Mailing list pgsql-novice

> > create unique index fooi on foo (lower(substring(name FROM '^\s*(\S*)\s*$')));
>
> > but (at least in postgres 7.4.13) the use of substring doesn't
> > work...
>
> You need to double those backslashes.

Thanks very much Tom, I realized something was wrong after I posted
again, but decided to refrain from posting again to reduce my "noise".
:)